SAVEPOINT

Scope

SQL Syntax

  SAVEPOINT [:HostVariable
             :LocalVariable
             :ProcedureParameter]

Parameters

HostVariable

identifies an output host variable used to communicate the savepoint number. The host variable's value can be from 1 to (2³¹)-1. In an application program, you must use a host variable with the SAVEPOINT statement. In a procedure, you must use either a local variable or a procedure parameter with the SAVEPOINT statement.

When you enter a SAVEPOINT statement interactively, you cannot specify a host variable. ISQL assigns and displays the savepoint number as follows:

   isql=> savepoint;
   Savepoint number is n.
   Use this number to do ROLLBACK WORK to n.

LocalVariable

contains a value in a procedure. Identifies an output host variable used to communicate the savepoint number. The host variable's value can be from 1 to (2³¹)-1.

ProcedureParameter

contains a value that is passed into or out of a procedure. Identifies an output host variable used to communicate the savepoint number. The host variable's value can be from 1 to (2³¹)-1.

Description

• Specify the savepoint number in the TO clause of a ROLLBACK WORK statement to roll back to a savepoint.

• If a procedure invoked by a rule executes a COMMIT WORK statement, an error occurs.

Authorization

Example

   BEGIN WORK
   statement-1
   SAVEPOINT :MyVariable
   statement-2
   statement-3

   ROLLBACK WORK
          TO :MyVariable

   COMMIT WORK