updatable_statement_isolation option

Specifies the isolation level used by updatable statements when the isolation_level option is set to Readonly-statement-snapshot.

The isolation level specified by the updatable_statement_isolation option is used by updatable statements when the isolation_level option is set to Readonly-statement-snapshot. The following values are accepted:

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 non-repeatable reads. Allow phantom rows.
3 Serializable. Prevent dirty reads, non-repeatable reads, and phantom rows.

updatable_statement_isolation option

Allowed values

Default

Scope

Remarks

See also