sql syntax

[Former Member]

Hi.

I'm just curious about what is mean '.'(dot) and '@' in Native SQL?

for example

select * from aa.bb@cc

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?

thanks in advance.

[Former Member · Accepted solution]

Hi,

Pl ref

Regards

[Former Member · Accepted solution]

thanks.

but connection is not issue.

I have check db connection is ok and confirmed by basis.

problem is native sql syntax itself.

I refered other system and they just select from aa.bb@cc and knowing that work fine.

but I don't know what should be fill up at aa and bb, cc

[Former Member · Accepted solution]

Hi,

In your case,

aa.bb@cc

normally this is used as under

aa=sapschema like sapD01 or sapP01 etc ie sap<SID>

bb=table name like mara,ekpo etc

so when i connect to mara table of D01 i use SAPD01.MARA and when i connect to same table of P01 i use SAPP01.MARA.

cc=Oracle database service name normally defined in tns.ora files

Regrds

[Former Member · Accepted solution]

Thank you

your answer is helpful to me

Regards.