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.

Adabas SQL Gateway Embedded SQL Specifics

The keyword WORK is optional.

 

Example

 

ROLLBACK WORK ;