sqlIsolationLevel

The vgVar.sqlIsolationLevel system variable indicates the level of independence of one database transaction from another, and is meaningful only for Java™ generation where you call vgLib.connectionService().

For an overview of isolation level and of the phrases repeatable read and serializable transaction, refer to the JDBC documentation available from Oracle.

Use vgVar.sqlIsolationLevel only in programs migrated from VisualAge® Generator, when you are running in VisualAge Generator compatibility mode. For new development, set the SQL isolation level when you use the sqlLib.connect() function.

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

0 (the default)
Repeatable read
1
Serializable transaction

You cannot use vgVar.sqlIsolationLevel as the target of a move statement.

vgVar.sqlIsolationLevel has the following characteristics:
Primitive type
NUM
Data length
1
Value saved across segmented converse?
Yes

Feedback