SAVEPOINT statement

Description

Establishes a savepoint within the current transaction.

Syntax

SAVEPOINT [ savepoint-name ]

Usage

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.


Side effects

None.

Standards

Permissions

None.

See also