topic Re: DB Connect and Database Views in Application Development and Automation Discussions

DB Connect and Database Views

Former Member — Tue, 16 Aug 2005 21:00:00 GMT

Hello,

I am writing a function module to access an external Oracle database that has been defined in our ABAP system using DBConnect.

I would like to use Open SQL instead of Native SQL to access the data in the remote table. Is this possible? I believe that in order to do this, a view of the remote table would have to be defined in the ABAP data dictionary via SE11, but I am unable to do this.

Does anyone know if this is possible, or am I required to use Native SQL when accessing an external database?

Regards,

-Matt Schababerle

Re: DB Connect and Database Views

Former Member — Wed, 17 Aug 2005 03:49:34 GMT

Hi,

Chek out these two links.

It would be helpful:

Regards,

Anjali

Re: DB Connect and Database Views

Former Member — Wed, 17 Aug 2005 04:34:57 GMT

hi Matt,

search forum for this

i have seen many threads on this.

regards.

Re: DB Connect and Database Views

Former Member — Wed, 17 Aug 2005 19:41:39 GMT

Thanks very much! I looked for threads on native SQL, but did not search past the begining of this year. The link was exactly what i was looking for!

-Matt