The COMMIT statement terminates a transaction and makes permanent all changes that were made to the database during the terminated transaction.
|
Embedded Mode P |
Dynamic Mode P |
Interactive Mode P |
The COMMIT statement terminates the current transaction and starts a new transaction. All changes to the database that have been made during the terminated transaction are made permanent. All cursors that have been opened during the current transaction are closed.
The KEEPING ALL is currently ignored by the Adabas SQL Gateway.
The keyword WORK is mandatory. The keywords KEEPING ALL are not part of the Standard.
The keyword KEEPING ALL is an Adabas SQL Gateway Embedded SQL extension.
Example
The following example commits all changes made to the database in the current transaction.
COMMIT WORK;