ROLLBACK WORK
Description
Ends the current transaction and undoes any database changes performed during the transaction.
Syntax
ROLLBACK [ WORK ] ;
Notes
Under certain circumstances, FairCom DB 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 FairCom DB SQL to recognize the transaction as marked for abort, and instead implicitly rolls back the transaction. FairCom DB SQL marks a transaction for abort under these conditions:
Authorization
None.
SQL Compliance |
SQL-92. |
Environment |
Embedded SQL and interactive |
Related Statements |
COMMIT WORK |