Database Access Commands › Navigational DML › ROLLBACK

ROLLBACK

Purpose

Requests recovery of the part of a run unit that falls between two checkpoints (a recovery unit).

Syntax

►►─── ROLLBACK ────┬────────┬────┬────────────┬───────── . ───────────────────►◄
                   └─ TASK ─┘    └─ CONTINUE ─┘

Parameters

TASK

Specifies that database, queue, and scratch areas are recovered.

If TASK is not specified, only database areas are recovered.

CONTINUE

Rolls back the issuing run unit (ROLLBACK CONTINUE) or all run units associated with the issuing task (ROLLBACK TASK CONTINUE), but does not terminate the run unit. Database access can be resumed without issuing BIND and READY statements.

Usage

Definition

ROLLBACK performs the following functions:

• Writes an ABRT checkpoint to the CA IDMS/DB journal file.
• Nullifies all currencies.
• Terminates database activities within the process and, if no database commands are issued after the ROLLBACK command, relinquishes control over database areas. If other database commands are issued after the ROLLBACK command, the database areas are readied again automatically in the applicable usage modes.

Considerations

After successful execution of a ROLLBACK command, database, queue, and scratch areas are restored to the most recent checkpoint.

The only acceptable status code returned for a ROLLBACK command is 0000.