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 is read 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.