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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Configuring Your Database » 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.

Allowed values

0, 1, 2, 3

Default

0

Remarks

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.

See also