The LIBNAME Statement for Relational Databases READ_LOCK_TYPE= LIBNAME Option 119
Syntax Description
See the documentation for your SAS/ACCESS interface for the values for your DBMS.
Details
The degree of isolation defines
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
READ_LOCK_TYPE= is not set to ROW.
See Also
To apply this option to an individual data set, see the data set option
“READ_ISOLATION_LEVEL= Data Set Option” on page 206.
READ_LOCK_TYPE= LIBNAME Option
Specifies how data in a DBMS table is locked during a READ transaction
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
READ_LOCK_TYPE= ROW | PAGE | TABLE | NOLOCK |VIEW
Syntax Description
ROW
locks a row if any of its columns are accessed. If you are using the interface to ODBC
or DB2 UNIX/PC, READ_LOCK_TYPE= ROW indicates that locking is based on the
READ_ISOLATION_LEVEL= option. (This value is valid in the DB2 UNIX/PC,
Microsoft SQL Server, ODBC, OLE DB, and Oracle interfaces.)
PAGE
locks a page of data, which is a DBMS-specific number of bytes. (This value is valid
in the SYBASE interface.)
TABLE
locks the entire DBMS table. If you specify READ_LOCK_TYPE=TABLE, you must
also specify CONNECTION= UNIQUE, or you receive an error message. Setting
CONNECTION=UNIQUE ensures that your table lock is not lost, for example, due to
another table closing and committing rows in the same connection. (This value is
