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 ...