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

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

updatable_statement_isolation option

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

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY PUBLIC OPTION Yes Yes, with SET ANY PUBLIC OPTION
Allowed to set temporarily? Yes, with SET ANY PUBLIC OPTION Yes (current connection only) No
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.