topic Re: simple sql syntax in Application Development and Automation Discussions

simple sql syntax

Former Member — Tue, 20 Nov 2007 08:16:09 GMT

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 — Tue, 20 Nov 2007 08:31:57 GMT

SELECT * FROM ZTABLE INTO TABLE ITAB CONNECTION CON_NAME.

Former Member — Tue, 20 Nov 2007 09:16:08 GMT

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?