Question on JDBC adapter

[Former Member]

Hi All,

here multiple records are coming from source, scenario is File to Jdbc.

So I want to do Update, Delete and Insert simultaneously. Will it be possible to do all different statements with single JDBC adapter at single hit. I don't want to use stored procedure. Can any one help me.

Thanks

[Former Member]

Hi Kumar,

Check thread

Good brain storming from all aspects for JDBC adapter.

Regards

Sushl

[Former Member]

Hi,

Yes, I don't see any trouble in doing so. Surely you can combine the various statements given in http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm in 1 statement. Just duplicate the target message the required number of times and add conditions for each statement as appropriate.

This way will be transactional - all statements will be executed in one transaction and if any one wails rollback will be performed.

Regards,

Daniel