ROLLBACK statement

Ends a transaction and undo any changes made since the last COMMIT or ROLLBACK.

Syntax

ROLLBACK [ WORK ]

Remarks

A transaction is the logical unit of work done on one database connection to a database between COMMIT or ROLLBACK statements. The ROLLBACK statement ends the current transaction and undoes all changes made to the database since the previous COMMIT or ROLLBACK.

Privileges

None.

Side effects

Closes all cursors not opened WITH HOLD.

Standards

ANSI/ISO SQL Standard
Not in the standard.