| SQL support / Database transactions | |
Validates and terminates a database transaction in the current connection.
COMMIT WORK
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.