Updating in JDBC receiver adapter

[Former Member]

Hi Friends,

I came across in the some sdn blogs, Like JDBC to JDBC scenarios i found that in the receiver JDBC adapter there is no place to write update statement or insert statement.Then how the records get updated in the DB.

My actual need is to update the oracle db from sap, which currently using the following statement

Loop at it_trn_ctl into WA_TRN_CTL.

UPDATE TableA SET SAP_UPDATE = 'Y'

WHERE PARENT_ID = :WA_TRN_CTL-PARENT_COIL .

end loop.

should replaced by XI, using the proxy to jdbc receiver. Where i can write the update statement and the where condition.

Kindly revert back for queries.

Thanks in advance

Karthikeyan

[Former Member]

answered

[Former Member]

If your jdbc is receiver, then you must use the insert statement and update statement as a xml format. refer:

xml document format for insert,delete,update statements

http://help.sap.com/erp2005_ehp_03/helpdata/EN/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm

[dharamveer_gaur2]

hi

for updation no need to write any query,use update structure at reciever side

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

this contains action:udate and then

key1: field that u want to update.

key2:pass old value of field for matching(where conditon matching field)

Edited by: Dharamveer Gaur on Sep 19, 2008 8:40 AM