UPDATE_LOCK_TYPE= LIBNAME Option

Specifies how data in a DBMS table is locked during an update transaction.
Valid in: SAS/ACCESS LIBNAME statement
Default: DBMS-specific
Data source: DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata
See: UPDATE_LOCK_TYPE= data set option, SCHEMA= LIBNAME option

Syntax

UPDATE_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK |VIEW

Syntax Description

ROW [valid for DB2 under UNIX and PC Hosts, Microsoft SQL Server, ODBC, Oracle]
locks a row if any of its columns are to be updated.
PAGE [valid for Sybase]
locks a page of data, which is a DBMS-specific number of bytes. This value is not valid for the Sybase interface when you use the .
TABLE [valid for DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, ODBC, Oracle, Sybase IQ, Teradata]
locks the entire DBMS table.
NOLOCK [valid for Microsoft SQL Server, ODBC with Microsoft SQL Server driver, OLE DB, Oracle, Sybase]
does not lock the DBMS table, page, or any rows when reading them for update.
VIEW [valid for Teradata]
locks the entire DBMS view.

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 locking topic for your interface in the DBMS-specific reference section for details.