sqlIsolationLevel

The system variable VGVar.sqlIsolationLevel indicates the level of independence of one database transaction from another.

For an overview of isolation level and of the phrases repeatable read and serializable transaction, see the JDBC documentation available from Sun Microsystems, Inc.

VGVar.sqlIsolationLevel is for use only in programs migrated from VisualAge® Generator and EGL 5.0. The function is supported (at development time) if the EGL preference VisualAge Generator Compatibility is selected or (at generation time) if the build descriptor option VAGCompatibility is set to yes.

For new development, set the SQL isolation level in the SysLib.connect.

The following values of VGVar.sqlIsolationLevel are in order of increasing strictness:

0 (the default)
Repeatable read
1
Serializable transaction
You can use this variable in any of these ways:
  • As the source or target in an assignment or move statement
  • In a function invocation, as an argument associated with an in, out, or inOut parameter
  • As a comparison value in a logical expression
  • As the value in a return statement
Characteristics of SysVar.transactionID are as follows:
Primitive type
NUM
Data length
1
Is value always restored after a converse?
Yes
Feedback
(C) Copyright IBM Corporation 2000, 2005. All Rights Reserved.