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.

Copyright © 2005. Sybase Inc. All rights reserved.

View this book as PDF