Establishes 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. SeeChapter 8, “Using Procedures and Batches” of the Sybase IQ System Administration Guide.
Savepoints that are established while a trigger is executing or while an atomic compound statement is executing are automatically released when the atomic operation ends.
None.
Sybase Not supported in Adaptive Server Enterprise. To implement similar features in an Adaptive Server Enterprise-compatible manner, you can use nested transactions.
None.