Contents Index ROLLBACK TRIGGER statement SELECT statement

ASA SQL Reference
  SQL Statements

SAVEPOINT statement


Description 

Use this statement to establish 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. 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.

Permissions 

None.

Side effects 

None.

See also 

RELEASE SAVEPOINT statement

ROLLBACK TO SAVEPOINT statement

Standards and compatibility 

Contents Index ROLLBACK TRIGGER statement SELECT statement