ROLLBACK

Function

The ROLLBACK statement terminates a transaction and removes all changes to the database that were made during the current transaction.

 

Syntax

rollback.bmp
 

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.

 

Limitations

None.

 

ANSI Specifics

The keyword WORK is mandatory.

 

CONNX Specifics

The keyword WORK is optional.

 

Example

 

ROLLBACK WORK ;