Technical data

ROLLBACK

Function

The ROLLBACK statement ends your database transaction, nulliﬁes all database

changes made by this run unit since its last quiet point, and establishes a new

quiet point for this run unit.

General Format

ROLLBACK

STREAM

ON ERROR stment

NOT

ON ERROR stment2

END-ROLLBACK

stment

is an imperative statement executed for an on error condition.

stment2

is an imperative statement executed for a not on error condition.

Syntax Rules

1. The STREAM clause cannot be speciﬁed if the subschema entry (DB) does not

name a stream.

General Rules

1. The ROLLBACK statement ends your database transaction.

2. All keeplists are emptied.

3. If you do not use the STREAM clause, the ROLLBACK statement does the

following:

• Nulliﬁes all database changes made by the run unit since the last quiet

point

• Terminates the ready mode of all ready realms for the run unit

• Establishes a new quiet point for the run unit

4. If you use the STREAM clause, the ROLLBACK statement does the

following:

• Nulliﬁes all database changes made by this stream since the last quiet

point

• Terminates the ready mode of all ready realms for this stream

• Establishes a new quiet point for this stream

5. All currency indicators are set to null.

6. All realm and record locks are released. These records and realms are now

available to concurrent run units.

7. To begin another transaction, the program must execute another READY

statement after it executes the ROLLBACK statement.

8. If the run unit abnormally terminates, the DBCS executes an implicit

ROLLBACK statement.

Procedure Division 4–57