ROLLBACK
Function
The ROLLBACK statement terminates a transaction and removes all changes to the database that were made during the current transaction.
Invocation
Embedded Mode P Dynamic Mode P Interactive Mode P
Syntax
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.
The KEEPING ALL is currently ignored by the Adabas SQL Gateway.
Limitations
None.
ANSI Specifics
The keyword WORK is mandatory. The keywords KEEPING ALL are not supported.
CONNX Embedded SQL Specifics
The keyword WORK is optional.
Example:
ROLLBACK WORK ;