User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To cancel any changes made since a SAVEPOINT.

Syntax

     ROLLBACK TO SAVEPOINT [savepoint-name]

Usage

Anywhere.

Permissions

There must have been a corresponding SAVEPOINT within the current transaction.

Side effects

None.

See also

• SAVEPOINT statement
• RELEASE SAVEPOINT statement
• ROLLBACK statement

Description

The ROLLBACK TO SAVEPOINT statement will undo any changes that have been made since the SAVEPOINT was established. Changes made prior to the SAVEPOINT are not undone; they are still pending. For a description of savepoints, see "Savepoints within transactions".

The savepoint-name is an identifier that was specified on a SAVEPOINT statement within the current transaction. If savepoint-name is omitted, the most recent savepoint is used. Any savepoints since the named savepoint are automatically released.