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.
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).
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.