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.
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |