Chapter Contents

Previous

Next
UPDATE_ISOLATION_LEVEL=

UPDATE_ISOLATION_LEVEL=



Defines the degree of isolation of the current application process from other concurrently running application processes

Default value: RC
Alias: UIL=


Syntax
Details

Syntax

UPDATE_ISOLATION_LEVEL=S | RC | RR | V

S = Serializable
RC = Read Committed
RR = Repeatable Read
V = Versioning


Details

The degree of isolation identifies

UPDATE_ISOLATION_LEVEL= is ignored if UPDATE_LOCK_TYPE= is not set to ROW.

The ODBC driver manager supports four isolation levels. The isolation levels are defined in terms of several possible occurrences:

The isolation levels for UPDATE_ISOLATION_LEVEL= include the following:


Chapter Contents

Previous

Next

Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.