The LIBNAME Statement for Relational Databases UPDATE_MODE_WAIT= LIBNAME Option 131
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_LOCK_TYPE= ROW | PAGE | TABLE | NOLOCK |VIEW
Syntax Description
ROW
locks a row if any of its columns are going to be updated. (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. (This value is valid in the DB2 OS/390, DB2 UNIX/PC,
ODBC, Oracle, Microsoft SQL Server, and Teradata interfaces.)
NOLOCK
does not lock the DBMS table, page, or any rows when reading them for update. (This
value is valid in the Microsoft SQL Server, ODBC, Oracle and SYBASE interfaces.)
VIEW
locks the entire DBMS view. (This value is valid in the Teradata interface.)
Details
You can set a lock for one DBMS table by using the data set option or for a group of
DBMS tables by using the LIBNAME option.
See the documentation for your SAS/ACCESS interface for additional details.
See Also
To apply this option to an individual data set, see the data set option
“UPDATE_LOCK_TYPE= Data Set Option” on page 214.
UPDATE_MODE_WAIT= LIBNAME Option
Specifies during SAS/ACCESS update operations whether Teradata should wait to acquire a lock or
fail the request when the DBMS resource is locked by a different user
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: Teradata
Default value: none
