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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Options » Introduction to database options » Alphabetical list of options

integrated_server_name option [database] Next Page

isolation_level option [compatibility]

Controls the locking isolation level.

Allowed values

0, 1, 2, 3, snapshot, statement-snapshot, readonly-statement-snapshot



1 for Open Client, jConnect, and TDS connections


Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.


This option controls the locking isolation level as follows:

See Isolation levels and consistency.

The allow_snapshot_isolation option must be set to On to use the snapshot, statement-snapshot, or readonly-statement-snapshot settings.

If you are using the iAnywhere JDBC driver, the default isolation level is 0.

Queries running at isolation level snapshot, statement-snapshot, or readonly-statement-snapshot see a snapshot of a committed state of the database.

You can override any temporary or public settings for this option within individual INSERT, UPDATE, DELETE, or SELECT statements by including an OPTION clause in the statement. See:

See also