Documentation

SQL Reference Guide

Previous Topic

Next Topic

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:

  • Hardware or software system failures
  • Lock timeout errors

Authorization

None.

SQL Compliance

SQL-92.

Environment

Embedded SQL and interactive

Related Statements

COMMIT WORK

TOCIndex