ROLLBACK WORK

Description

Ends the current transaction and undoes any database changes performed during the transaction.

Syntax

ROLLBACK [ WORK ] ;

Notes

Under certain circumstances, c-treeACE SQL marks a transaction for abort but does not actually roll it back. Without an explicit rollback, any subsequent updates will not take effect, since a COMMIT statement cause c-treeACE SQL to recognize the transaction as marked for abort, and instead implicitly rolls back the transaction. c-treeACE SQL marks a transaction for abort under these conditions:

• Hardware or software system failures
• Lock timeout errors

Authorization

None.