topic Re: using native sql for update in Application Development and Automation Discussions

using native sql for update

former_member608640 — Sun, 20 Nov 2011 07:41:47 GMT

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

Re: using native sql for update

kesavadas_thekkillath — Mon, 21 Nov 2011 04:43:16 GMT

Hi,

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

Kesav

Re: using native sql for update

former_member608640 — Mon, 21 Nov 2011 08:37:34 GMT

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.

Re: using native sql for update

SuhaSaha — Mon, 21 Nov 2011 09:13:07 GMT

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