UPDATE_LOCK_TYPE= LIBNAME Statement Option

Specifies how data is locked during an update transaction.

Valid in: LIBNAME statement
Default: data source-specific
Supports: DB2 under UNIX and PC, MySQL, ODBC, Oracle, Teradata
Syntax
Syntax Description
Details
See Also

Syntax

UPDATE_LOCK_TYPE= ROW | TABLE | NOLOCK

Syntax Description

ROW

locks a row if any of its columns are to be updated. (This value is valid for all the data sources that are listed for this option.)

TABLE

locks the entire table. (This value is valid for the SQL Server by using the ODBC table driver.)

NOLOCK

does not lock the table, page, or any rows when reading them for update. (This value is valid for the Oracle data source.)

Details

You can set a lock for one data source table by using the data set option if available, or for a group of tables by using the LIBNAME option.
For more information, see the reference documentation for your DBMS.

See Also

To apply this option to an individual table, use the UPDATE_LOCK_TYPE= data set option.
Copyright © SAS Institute Inc. All Rights Reserved.