COMMIT
Function
The COMMIT statement terminates a transaction and makes permanent all changes that were made to the database during the terminated transaction.
Syntax
COMMIT [WORK]
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.
ANSI Specifics
The keyword WORK is mandatory.
Examples
The following example commits all changes made to the database in the current transaction.
COMMIT WORK;