COMMIT WORK
Validates and terminates a database transaction in the current connection.
Syntax
COMMIT WORKUsage
Use the COMMIT WORK instruction
to commit all modifications made to the database from the beginning
of a transaction. The database server takes the required steps to
make sure that all modifications that the transaction makes are
completed correctly and saved to disk.
COMMIT WORK is
part of the language syntax, the underlying database driver executes
the native SQL statement corresponding to this SQL instruction.
The COMMIT WORK statement releases all exclusive
locks that have been set during the transaction. With some databases,
shared locks are not released if the FOR UPDATE cursor
is declared WITH HOLD option. However, the COMMIT
WORK statement closes all cursors not declared with the WITH
HOLD option.