Reference Manual
   CHAPTER 9. SQL Statements     

SAVEPOINT statement

Function 

To establish a savepoint within the current transaction.

Syntax 

SAVEPOINT [ savepoint-name ]

Permissions 

None.

Side effects 

None.

See also 

RELEASE SAVEPOINT statement

ROLLBACK TO SAVEPOINT statement

Description 

Establish a savepoint within the current transaction. The savepoint-name is an identifier that can be used in an 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.

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not supported in Adaptive Server Enterprise. To implement similar features in an Adaptive Server Enterprise-compatible manner, you can use nested transactions.