How commit and rollback operations work
Commit and rollback operations affect changes that are made under commitment control.
The following programming languages and application programming interfaces (APIs) support commit and rollback operations.
| Language or API | Commit | Rollback |
|---|---|---|
| CL | COMMIT command | ROLLBACK command |
| IBM® Integrated Language Environment® (ILE) RPG | COMIT operation code | ROLBK operation code |
| ILE COBOL | COMMIT verb | ROLLBACK verb |
| ILE C | _Rcommit function | _Rrollbck function |
| PLI | PLICOMMIT subroutine | PLIROLLBACK subroutine |
| SQL | COMMIT statement | ROLLBACK statement |
| SQL Call Level Interface (CLI) | SQLTransact() function (It is used to commit and roll back a transaction) | |
| XA APIs | xa_commit() and db2xa_commit() APIs | xa_rollback() and db2xa_rollback() APIs |
- Commit operation
A commit operation makes permanent all changes made under commitment control since the previous commit or rollback operation. The system also releases all locks related to the transaction. - Rollback operation
A rollback operation removes all changes made since the previous commit or rollback operation. The system also releases all locks related to the transaction.
Parent topic:
Commitment control concepts
Related concepts
SQL call level interface
Database programming
Related information
WebSphere development studio: ILE C/C++ programmer's guide PDF
CL programming
Application programming interfaces