130 UPDATE_ISOLATION_LEVEL= LIBNAME Option Chapter 9
Details
TRACEFILE= is used only when TRACE=YES. If you specify a filename without a
path, the SAS trace file is stored with your data files. If you specify a directory, enclose
the fully qualified filename in single quotation marks.
If you do not specify the TRACEFILE= option, output is directed to a default file.
This option is not supported on UNIX platforms.
See Also
“TRACE= LIBNAME Option” on page 129
UPDATE_ISOLATION_LEVEL= LIBNAME Option
Defines the degree of isolation of the current application process from other concurrently running
application processes
Valid in:
the SAS/ACCESS LIBNAME statement
DBMS support:
DB2 OS/390, DB2 UNIX/PC, ODBC, OLE DB, Oracle, Microsoft SQL
Server, SYBASE, Teradata
Default value:
DBMS-specific
Syntax
UPDATE_ISOLATION_LEVEL= DBMS-specific-value
Syntax Description
The values for this option are DBMS-specific. See the documentation for your
SAS/ACCESS interface.
Details
The degree of isolation defines the following
the degree with which rows that are read and updated by the current application
are available to other concurrently executing applications
the degree with which update activity of other concurrently executing application
processes can affect the current application.
In the interfaces to ODBC and DB2 UNIX/PC, this option is ignored if
UPDATE_LOCK_TYPE= is not set to ROW.
See Also
To apply this option to an individual data set, see the data set option
“UPDATE_ISOLATION_LEVEL= Data Set Option” on page 214.
UPDATE_LOCK_TYPE= LIBNAME Option
Specifies how data in a DBMS table is locked during an update transaction
