SQL Reference Guide

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