Show TOC

SAVEPOINT StatementLocate this document in the navigation structure

Establishes a savepoint within the current transaction.

Quick Links:

Go to Parameters

Go to Usage

Go to Standards

Go to Permissions

Syntax
SAVEPOINT [ <savepoint-name> ]
Parameters

(back to top)

  • savepoint-name an identifier that can be used in a RELEASE SAVEPOINT or ROLLBACK TO SAVEPOINT statement.
Usage

(back to top)

All savepoints are automatically released when a transaction ends.

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.

Standards

(back to top)

  • SQL—Vendor extension to ISO/ANSI SQL grammar.
  • SAP Database products—Not supported in SAP ASE. To implement similar features in an SAP ASE-compatible manner, use nested transactions.
Permissions
Related Information