SAVEPOINT statement
600
SAVEPOINT statement
Use this statement to establish a savepoint within the current transaction.
SAVEPOINT [
savepoint-name
]
None.
None.
"RELEASE SAVEPOINT statement" on page 588
"ROLLBACK TO SAVEPOINT statement" on page 598
Establish a savepoint within the current transaction. The savepoint-name is
an identifier that can be used in a RELEASE SAVEPOINT or ROLLBACK
TO SAVEPOINT statement. All savepoints are automatically released when
a transaction ends. See "Savepoints within transactions" on page 385 of the
book ASA User’s Guide.
Savepoints that are established while a trigger or atomic compound statement
is executing are automatically released when the atomic operation ends.
♦
SQL/92 Vendor extension. Included in the SQL/3 draft specification.
♦
Sybase Not supported in Adaptive Server Enterprise. To implement
similar features in an Adaptive Server Enterprise-compatible manner,
you can use the SAVE TRANSACTION statement.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
To Next Page
Loading...