ROLLBACK(l) SQL - Language Statements (2002-11-22) ROLLBACK(l) NAME ROLLBACK - abort the current transaction SYNOPSIS ROLLBACK [ WORK | TRANSACTION ] INPUTS None. OUTPUTS ROLLBACK Message returned if successful. WARNING: ROLLBACK: no transaction in progress If there is not any transaction currently in progress. DESCRIPTION ROLLBACK rolls back the current transaction and causes all the updates made by the transaction to be discarded. NOTES Use COMMIT [commit(l)] to successfully terminate a transaction. ABORT [abort(l)] is a synonym for ROLLBACK. USAGE To abort all changes: ROLLBACK WORK; COMPATIBILITY SQL92 SQL92 only specifies the two forms ROLLBACK and ROLLBACK WORK. Otherwise full compatibility. Page 1 (printed 3/24/03)[top]
Vote for polarhome |