SAVEPOINT statement

Description

Establishes a savepoint within the current transaction.

Syntax

SAVEPOINTsavepoint-name ]

Usage

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 Chapter 1, “Using Procedures and Batches” in the System Administration Guide: Volume 2.

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

RELEASE SAVEPOINT statement

ROLLBACK TO SAVEPOINT statement