COMMIT(l) SQL - Language Statements (2002-11-22) COMMIT(l)
NAME
COMMIT - commit the current transaction
SYNOPSIS
COMMIT [ WORK | TRANSACTION ]
INPUTS
WORK
TRANSACTION
Optional keywords. They have no effect.
OUTPUTS
COMMIT
Message returned if the transaction is successfully
committed.
WARNING: COMMIT: no transaction in progress
If there is no transaction in progress.
DESCRIPTION
COMMIT commits the current transaction. All changes made by
the transaction become visible to others and are guaranteed
to be durable if a crash occurs.
NOTES
The keywords WORK and TRANSACTION are noise and can be
omitted.
Use ROLLBACK [rollback(l)] to abort a transaction.
USAGE
To make all changes permanent:
COMMIT WORK;
COMPATIBILITY
SQL92
SQL92 only specifies the two forms COMMIT and COMMIT WORK.
Otherwise full compatibility.
Page 1 (printed 3/24/03)