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)[top]
Vote for polarhome |