IsolationLevel
Set the isolation level at which the application will run.
USYS$INF_PARAMS IsolationLevel
Arguments
IsolationLevel—set the Informix or ANSI isolation level.
Informix isolation levels are set after each connection using the SET
ISOLATION
SQL statement; allowed values are:
-
dirty read
-
committed read
-
cursor stability
-
repeatable read
ANSI isolation levels are set after each transaction using the SET
TRANSACTION
SQL statement; allowed values:
-
ansi read uncommitted
(Not allowed if access mode isread write
) -
ansi read committed
-
ansi repeatable read
-
ansi serializable
For more information on isolation levels, see your Informix documentation.
Use
It is not allowed to set Isolation level
to any value in combination with
Standard Engine.
Description
When this option is not present, the default isolation level set by Informix is used.