2.26 ROLLBACK WORK

---

Description

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

Syntax

ROLLBACK [ WORK ] ;

Notes

Under certain circumstances, c-treeSQL 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-treeSQL to recognize the transaction as marked for abort, and instead implicitly rolls back the transaction. c-treeSQL marks a transaction for abort under these conditions:

Hardware or software system failures
Lock timeout errors

Authorization

None.

SQL Compliance	SQL-92.
Environment	Embedded SQL and interactive
Related Statements	COMMIT WORK