Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

updatable_statement_isolation option [database]

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

0, 1, 2, 3

0

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.

• isolation_level option [compatibility]
• Snapshot isolation
• Isolation levels and consistency
• Choosing isolation levels