CONNX Data Integration Suite 14.8.0 | CONNX Embedded SQL for Adabas | Standard SQL Statements | COMMIT
 
COMMIT
Function
The COMMIT statement terminates a transaction and makes permanent all changes that were made to the database during the terminated transaction.
Invocation
Embedded Mode P Dynamic Mode P Interactive Mode P
Syntax
The syntax of the statement is COMMIT WORK, with optional KEEPING, and ALL.
Description
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.
ANSI Specifics
The keyword WORK is mandatory. The keywords KEEPING ALL are not part of the Standard.
Adabas SQL Gateway Embedded SQL Specifics
The keyword KEEPING ALL is an CONNX Embedded SQL extension.
Here is an example on how to commit all changes made to the database in the current transaction:
COMMIT WORK;