HP 3000 Manuals

IMAGE/SQL Administration Guide

Repeatable Read 

A repeatable read guarantees that data pages (for ALLBASE/SQL) or an
IMAGE/SQL dataset (for IMAGE/SQL) selected or updated by the current
transaction are not changed by other transactions until the current
transaction ends with a COMMIT WORK or ROLLBACK WORK statement.

For ALLBASE/SQL, a repeatable read is specified with the RR isolation
level in the BEGIN WORK statement.

For IMAGE/SQL, a repeatable read occurs if both of the following
conditions are met:

   *   The IMAGE/SQL database is opened in DBOPEN mode 1, 2, 3, or 4.
       The DBOPEN mode used by IMAGE/SQL is determined by the MODE
       attribute of the IMAGE/SQL user, which can be seen with the
       IMAGESQL DISPLAY USERS command, and modified with UPDATE USER.
       [REV BEG]

   *   The transaction was started with a BEGIN WORK statement using the
       isolation level RR, or by selecting data or modifying the database
       without explicitly using the BEGIN WORK statement.[REV END]

MPE/iX 5.5 Documentation