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 |