topic Re: SELECT secondary database SELECT * error in Application Development and Automation Discussions

SELECT secondary database SELECT * error

Former Member — Fri, 20 Dec 2013 02:34:56 GMT

Hi,

I have an Open SQL statement to select a secondary database. When using SELECT *, an error states that SQL error 207 when accessing table. If I specify the column names, the select statement works well. I want to know the underlining logic.

SELECT *

INTO CORRESPONDING FIELDS OF TABLE LT_MARA

FROM MARA

CLIENT SPECIFIED

CONNECTION T01

WHERE MANDT = '100'

Best regards,

ts.

Re: SELECT secondary database SELECT * error

Former Member — Fri, 20 Dec 2013 02:48:07 GMT

hi Ts

when you use CONNECTION to a secondary database, see the last statement.

... CONNECTION {con|(con_syntax)}

Note

This addition is for internal use only.
It cannot be used in application programs

Effect

The Open SQL command is not executed on the standard database but on the specified secondary database connection. The database connection can be specified statically with con or dynamically as the content of con_syntax, where the field con_syntax must belong to the type c or string. The database connection must be specified with a name that is in column CON_NAME in table DBCON.

regards,

Archer

Re: SELECT secondary database SELECT * error

Arun_Prabhu_K — Fri, 20 Dec 2013 02:53:14 GMT

Hello T S.

Can you paste the error screen shot here?

Regards.

Re: SELECT secondary database SELECT * error

Former Member — Fri, 20 Dec 2013 03:08:03 GMT

Re: SELECT secondary database SELECT * error

sivaganesh_krishnan — Fri, 20 Dec 2013 05:19:52 GMT

SQL Server: Refer to Note 1630727 to prevent SQL error 207: "Invalid column name 'area'"

Re: SELECT secondary database SELECT * error

nabheetscn — Fri, 20 Dec 2013 05:34:06 GMT

Do you have some ANIMAL_ORIGIN column in select as mentioned in dump first screen shot.?

Re: SELECT secondary database SELECT * error

Former Member — Fri, 20 Dec 2013 06:17:27 GMT

No, I just select data from MARA.

Re: SELECT secondary database SELECT * error

nabheetscn — Fri, 20 Dec 2013 07:32:14 GMT

Hi TS

Did you check DBCON entries for this secondary database are maitnained. Secondly please make sure both table have same field in both databased. Please verify

Nabheet

Re: SELECT secondary database SELECT * error

Former Member — Fri, 20 Dec 2013 09:51:31 GMT

Yes, connection has been confirmed by remote log-in. The no difference on structures.

Best regards,

Re: SELECT secondary database SELECT * error

nabheetscn — Fri, 20 Dec 2013 09:55:47 GMT

Can you please paste your code here...? DBCON entries are maintained? Please check SM21 after the dump to see if it provides you some more details. Please paste it here.

Re: SELECT secondary database SELECT * error

RaymondGiuseppi — Fri, 20 Dec 2013 10:01:43 GMT

It may come from the CORRESPONDING FIELDS.

If you execute the statement in a textile industry system and the native SQL statement in a non textile industry system. The list of corresponding field would come from calling database but the statement is executed on another database ?

Regards,

Raymond