topic Re: Can some open sql and native sql execute together in one LUW? in Application Development and Automation Discussions

Can some open sql and native sql execute together in one LUW?

Former Member — Tue, 30 Mar 2010 02:46:08 GMT

Now i am doing one interface between SAP and another system . Both of them use the oracle database .

So I am try to use open SQL and native SQL in one transaction , to commit the datas to both of them together.

Can anyone confirm this idea is work or not?

Anyone would show me the sample code is the best!

Re: Can some open sql and native sql execute together in one LUW?

SuhaSaha — Tue, 30 Mar 2010 03:10:38 GMT


> Now i am doing one interface between SAP and another system . Both of them use the oracle database .

If the other system is an SAP system i dont think you need to write Native SQL to update the DB. If not you have to use Native SQL to update the DB. For this specific purposes SAP has provided ADBC classes (ABAP DataBase Connectivity)

You can refer to the SAP demo program ADBC_DEMO to check how to implement these classes.

BR,

Suhas

Re: Can some open sql and native sql execute together in one LUW?

Former Member — Tue, 30 Mar 2010 03:29:22 GMT

Thank you Suhas, but another system is not SAP , I must use native SQL.

So, how to bind OPEN SQL and Native SQL in one LUW?

Re: Can some open sql and native sql execute together in one LUW?

wolfgang_brunneder — Tue, 30 Mar 2010 05:42:06 GMT

Hi Ivan!

I don't think there is something special to consider to bind open sql and native sql in one sap-luw. One possibility is to create a function module (update module) which encapsulates the db access and call it IN UPDATE TASK.

Regards

Wolfgang

Re: Can some open sql and native sql execute together in one LUW?

SuhaSaha — Tue, 30 Mar 2010 06:07:25 GMT

Hello Wolfgang,

I am not sure if a separate LUW is created for the external DB access. If my understanding is correct DB LUW is created for SAP DB, is it created for an external DB as well ?

BR,

Suhas