ISOLATION

Syntax:

ISOLATION={CS | RR | UR | RS | NC}

Parameters:

CS specifies Cursor Stability as the isolation level.
NC (No Commit) specifies that commitment control is not to be used. This isolation level is not supported by DB2.
RR specifies Repeatable Read as the isolation level.
RS specifies Read Stability as the isolation level. Read Stability ensures that the execution of SQL statements in the package is isolated from other application processes for rows read and changed by the application.
UR specifies Uncommitted Read as the isolation level.

Properties:

Default: ISOLATION=CS