ROLLBACK Statement (rollback_statement) 

The ROLLBACK statement cancels the current transaction and starts a new transaction.

Syntax

<rollback_statement> ::= ROLLBACK [WORK]

lock_statement

Explanation

The ROLLBACK statement cancels the current transaction. This means that any modifications made within the transaction are reversed. The locks assigned to the transaction are released.

The ROLLBACK statement implicitly opens a new transaction. Any locks set within the new transaction are assigned to this transaction. The setting of locks in the new transaction is controlled by the isolation level declared in the CONNECT statement (see Isolation Level).

All result tables generated within the current transaction are implicitly deleted at the end of the transaction using the ROLLBACK statement.