RELEASE SAVEPOINT statement
588
RELEASE SAVEPOINT statement
Use this statement to release a savepoint within the current transaction.
RELEASE 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
"ROLLBACK statement" on page 597
"ROLLBACK TO SAVEPOINT statement" on page 598
"SAVEPOINT statement" on page 600
"Savepoints within transactions" on page 385 of the book ASA User’s Guide
Release a savepoint. The savepoint-name is an identifier specified on a
SAVEPOINT statement within the current transaction. If savepoint-name is
omitted, the most recent savepoint is released.
Releasing a savepoint does not do any type of COMMIT. It simply removes
the savepoint from the list of currently active savepoints.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise. A similar
feature is available in an Adaptive Server Enterprise-compatible manner
using nested transactions.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
To Next Page
Loading...