ROLLBACK TO SAVEPOINT statement
598
ROLLBACK TO SAVEPOINT statement
To cancel any changes made since a SAVEPOINT.
ROLLBACK TO SAVEPOINT [
savepoint-name
]
There must have been a corresponding SAVEPOINT within the current
transaction.
None.
"BEGIN TRANSACTION statement" on page 407
"COMMIT statement" on page 420
"RELEASE SAVEPOINT statement" on page 588
"ROLLBACK statement" on page 597
"SAVEPOINT statement" on page 600
"Savepoints within transactions" on page 385 of the book ASA User’s Guide
The ROLLBACK TO SAVEPOINT statement will undo any changes that
have been made since the SAVEPOINT was established. Changes made
prior to the SAVEPOINT are not undone; they are still pending.
The savepoint-name is an identifier that was specified on a SAVEPOINT
statement within the current transaction. If savepoint-name is omitted, the
most recent savepoint is used. Any savepoints since the named savepoint are
automatically released.
♦
SQL/92 Vendor extension. Included in the SQL/3 draft specification.
♦
Sybase Savepoints are not supported by Adaptive Server Enterprise.
To implement similar features in an Adaptive Server Enterprise-
compatible manner, you can use nested transactions.
$ For more information on nested transactions, see "BEGIN
TRANSACTION statement" on page 407.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
To Next Page
Loading...