ASA SQL Reference
SQL Statements
Use this statement to establish a savepoint within the current transaction.
SAVEPOINT [ savepoint-name ]
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.
Savepoints that are established while a trigger or atomic compound statement is executing are automatically released when the atomic operation ends.
None.
None.
ROLLBACK TO SAVEPOINT statement
SQL/92 Vendor extension.
SQL/99 SQL/foundation feature outside of core SQL.
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.