Description

ISOLATION LEVEL
Specifies the isolation level of the transaction. If the ISOLATION LEVEL clause is not specified, ISOLATION LEVEL SERIALIZABLE is implicit
NO COMMIT
Specifies isolation level NC (COMMIT(*NONE)).
READ UNCOMMITTED
Specifies isolation level UR (COMMIT(*CHG)).
READ COMMITTED
Specifies isolation level CS (COMMIT(*CS)).
REPEATABLE READ 82
Specifies isolation level RS (COMMIT(*ALL)).
SERIALIZABLE
Specifies isolation level RR (COMMIT(*RR)).
READ WRITE or READ ONLY
Specifies whether the transaction allows data change operations.
READ WRITE
Specifies that all SQL operations are allowed. This is the default unless ISOLATION LEVEL READ UNCOMMITTED is specified.
READ ONLY
Specifies that only SQL operations that do not change SQL data are allowed. If ISOLATION LEVEL READ UNCOMMITTED is specified, this is the default.
DIAGNOSTICS SIZE
Specifies the maximum number of GET DIAGNOSTICS condition areas for the current transaction. The GET DIAGNOSTICS statement-information-item MORE will be set to 'Y' for the current statement if the statement exceeds the maximum number of condition areas for the current transaction. The specified maximum number of condition areas must be between 1 and 32767.
integer
An integer constant that specifies the maximum number of condition areas for the current transaction.
variable
Identifies a variable which contains the maximum number of condition areas for the current transaction. The variable must be a numeric variable with a zero scale and must not be followed by an indicator variable.

82.
REPEATABLE READ is the ISO and ANS standard term that corresponds to the isolation level of *ALL for DB2 UDB for iSeries and the isolation level of Read Stability (RS) in IBM(R) SQL. SERIALIZABLE is used in the ISO and ANS standard for what IBM SQL calls Repeatable Read (RR).