using native sql for update

[former_member608640]

Hello ,

I have a reqaust to update a db table declared "outside" our R3 db.

I mennage to select the data using native sql with a connection to the db.

Now i need to modify the data on the db.

Is there a similliar command like "fetch next" ' for update?

Mybe i need to build a procedure in th "host" db and use its own commands to update?

Thanks,

koby

[kesavadas_thekkillath]

Hi,

have a look at [Stored Procedures|http://help.sap.com/saphelp_bw/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm]

Kesav

[former_member608640]

hi Kesav,

The link merge a lot of useful information i found when i "dive" into sap info...,thank you for this.

I plan to use a stored procedure to handle update\insert\delete on the "foreign" DB .

I hope there is one written allready , so i dont need to learn the syntax of the "foreign" env...

koby.

[SuhaSaha]

Hello Kobi,

Which release of SAP are you woking on?

If you're on ECC6.0, instead you using Native SQL to call the stored procs of external DBs you can use the [ADBC APIs |http://help.sap.com/abapdocu_702/en/abenadbc_procedure.htm](CL_SQL* classes).

BR,

Suhas