User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To establish a savepoint within the current transaction.

Syntax

     SAVEPOINT [savepoint-name]

Usage

Anywhere.

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 is executing or while an atomic compound statement is executing are automatically released when the atomic operation ends.