JDBC Receiver - Multiple rows Update

[Former Member]

I have an interface the incoming message contain multiple columns and it has to be updated using a JDBC Receiver Adapter with its key values.

Can we send multiple rows in a single JDBC Update Statement.

Please advise.

[justin_santhanam]

Sebin,

No ,it's not possible to have multiple rows in single update statement. Rather you can duplicate the segment at Statement level and do the update.

Please refer http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

raj.

[VijayKonam]

The above solution would work but, there would be multiple calls between XI and SQL system which might increase the traffic in network.

I would use an UDF and put all the values in a single string and call an SP in the receiver JDBC channel so that all the data is sent to SQL at once. In this case, the SQL SP has to decrypt the data in the parameter and insert it appropriately as needed by your business requirement.

VJ

[Former Member]

sorry for the wrong reply

Message was edited by:

Ramesh P