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.
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.
