sysVar.sqlIsolationLevel

The system variable sysVar.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.

sysVar.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 sysVar.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 destination in an assignment or move statement

• 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

Related reference
sysLib.connect