sql syntax

[Former Member]

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.

[Former Member]

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

[Former Member]

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?

[Former Member]

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

[Former Member]

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

[Former Member]

found answers