ROLLBACK
Function
The ROLLBACK statement terminates a transaction and removes all changes to the database that were made during the current transaction.
Syntax
ROLLBACK [WORK]
Description
The ROLLBACK statement terminates the current transaction and starts a new transaction. All changes to the database that have been made during the transaction are not applied and the database is as it existed at the time the transaction was started. All cursors that have been opened during the current transaction are closed.
ANSI Specifics
The keyword WORK is mandatory.
CONNX Specifics
The keyword WORK is optional.
Example
ROLLBACK WORK ;