Providing COMMIT statements in the application code
To make sure that every database operation gets committed, perform one of the following operations:
▪ Execute the statement COMMIT WORK.
▪ Call ODBC function SQLTransact or SQLEndTran.
▪ Call JDBC method commit.
Make sure that these operations succeed by checking the return code or by properly catching the possible exception. Be aware of how many database connections your application has, when and where they are created, and when the transactions at these connections are committed.