topic sql syntax in Application Development and Automation Discussions

sql syntax

Former Member — Wed, 21 Nov 2007 02:15:46 GMT

Hi.

I'm just curious what is mean '.'(dot) and '@' in native sql?

for example

select * from aa.bb@cc

what should be placed to 'aa' position and 'bb' and 'cc'?

thanks in advance.

Re: sql syntax

Former Member — Wed, 21 Nov 2007 02:49:00 GMT

Hi,

Can you explain more clearly as what did you want to achieve. As SQL (SELECT) is used to get the data from DB table. so FROm <table name>.

Why do you want aa.bb@cc

instead of table name.

Regards,

Atish

Re: sql syntax

Former Member — Wed, 21 Nov 2007 03:28:33 GMT

yes.

sorry I didn't explain cleary.

reason I need to use aa.bb.@cc instead of Open SQL is that table isn't exist on SAP server and more than that external server is Non-SAP server.

I have seen some example that case like above sql but didn't figure out how to use this time.

in my case suppose db connection is 'dbcon' and external server's oracle SID is 'ora1' and target table is 'table1' .

how to specify target table with this information?

or do I need to know something else to put 'from' statement?

Re: sql syntax

Former Member — Wed, 21 Nov 2007 03:30:48 GMT

Hi,

In this case you need to use NATIVE SQL. I haven't worked much on it so can't tell you the code..but you can search the forum or check in help.sap.com

Regards,

Atish

Re: sql syntax

Former Member — Wed, 21 Nov 2007 04:24:27 GMT

Ok thanks.

I tried search forum but think not much case like me

I will post DB forum too.

by the way Anyone who get used to Native SQL and can help me?

Regards.

Park

Re: sql syntax

Former Member — Wed, 21 Jan 2009 04:58:24 GMT

found answers