Originally posted by: RT123

Hi Paul,

Have a query w.r.t inserting records into DB table, on a record by record basis and commit at the same time.  I have a file which has suppose 10 records, i want to insert the records one at a time and also commit at the same time, per record rather than doing a DB commit at the end of the 10 record insertion.

Thanks,

Originally posted by: GertieKearney

Hi,

I enclose documentation link to Commit by Statement as follows.

https://www.ibm.com/support/knowledgecenter/en/SSVSD8_9.0.0/com.ibm.websphere.dtx.adaps.doc/references/r_adapterslib_Commit_by_Statement_CS_or_CSTMT.htm

Extract :

In an example for a target, if an output card is a database table for which the Update adapter command (-UPDATE) has also been specified, the Commit by Statement adapter command (-CSTMT) would cause each row to be committed as it is inserted or updated into the database.

List of commands

https://www.ibm.com/support/knowledgecenter/SSVSD8_9.0.0/com.ibm.websphere.dtx.adaps.doc/references/r_adapterslib_List_of_Commands.htm

Gertie.