Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Updating in JDBC receiver adapter

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
Not what you were looking for? View more on this topic or Ask a question