SQL Anywhere® Server - Database Administration  > Database Options  > Introduction to database options  > Alphabetical list of options

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