ISOLATION

Determines how far a program bound to this package can be isolated from the effect of other executing programs. For more information about isolation levels, see the IBM DB2 SQL Reference.

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