iAnywhere.com - ISOLATION_LEVEL option [compatibility]

Controls the locking isolation level.

0, 1, 2, 3

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

1 for Open Client and JDBC connections

This option controls the locking isolation level as follows.

0 Allow dirty reads, non-repeatable reads, and phantom rows.
1 Prevent dirty reads. Allow non-repeatable reads and phantom rows.
2 Prevent dirty reads and guarantee repeatable reads. Allow phantom rows.
3 Serializable. Do not allow dirty reads, guarantee repeatable reads, and do not allow phantom rows.