COMMIT
|
This document covers the following topics:
Belongs to Function Group: Database Access and Update
The SQL COMMIT
statement corresponds to the
END TRANSACTION
statement. It indicates the end of a logical transaction and releases all data
locked during the transaction. All data modifications are committed and made
permanent.
Important:
As all cursors are closed when a logical unit of work ends,
a COMMIT
statement must not be placed within a database
modification loop; instead, it has to be placed outside such a loop or after
the outermost loop of nested loops.
... DELETE FROM SQL-PERSONNEL WHERE NAME = 'SMITH' COMMIT ...