rollback transaction

Description

Rolls back a user-specified transaction to the beginning of the transaction.

Syntax

rollback {transaction | tran | work}
 [transaction_name]

Parameters

tran: is another term for transaction.

work: is another term for transaction.

transaction_name: is the name assigned to the transaction. It must conform to the rules for identifiers.

Examples

Example 1

rollback transaction

Usage

In sybase mode, transaction_name is stripped from the statement before it is passed to the target.
The DB2 access service converts rollback transaction, rollback work, and rollback tran statements to a rollback statement.