Commits all changes made during the current transaction.
You must specify either a THEN clause, an ELSE clause, or both a THEN and an ELSE clause. If the transaction commit is successful, the THEN clause is executed. If the transaction commit fails, the ELSE clause is executed. The
statements argument can be the
NULL keyword, a single statement, or a block of statements terminated by the
END keyword. A block of statements has specific line break requirements: each statement must be on its own line and cannot follow a THEN, ELSE, or END keyword on that line.
File locks and record locks that were taken out during a transaction are released at the end of a transaction. If there are nested transactions, the release of locks taken out during the inner transactions is delayed until the completion of the outermost transaction. This release of locks is part of a successful
TRANSACTION COMMIT or
TRANSACTION ABORT operation. Locks are described in the
LOCK statement.