Product 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 the following exceptional circumstances a commit or a commit to a savepoint may fail causing all changes to be rolled back:

  • Lock timeout errors
  • Hardware errors
  • Software errors
  • Storage space failures

Authorization

None.

SQL Compliance

SQL-92.

Environment

Embedded SQL and interactive

Related Statements

COMMIT WORK

TOCIndex