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

[Former Member]

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!

[SuhaSaha]

>

> 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

[Former Member]

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?

[wolfgang_brunneder]

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

[SuhaSaha]

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