simple sql syntax

[Former Member]

hi.

I'd like to use external server's tables.

and DB connection has made.

but I don't know how to specify external table on sql in 'from' blank.

suppose oracle sid is "oracle1" and target table is "t_table".

how to make simple select SQL query?

if not possible specify target table with that name what other information need to be known?

data :aaa type string.

EXEC SQL select field1 into :aaa from ENDEXEC.

Thank you in advance

park.

[Former Member]

SELECT * FROM ZTABLE INTO TABLE ITAB CONNECTION CON_NAME.

[Former Member]

thanks

but external server is not SAP server so there is NO ordinary connection name

DB connection is made by unix parameter

anyway I only can use native SQL not open SQL.

I know external server's oracle SID and target table name. in that situation how to specify non-sap server's table to 'from' of native SQL query?