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 UNIX/PC, MySQL, ODBC, Oracle, Teradata |
Syntax
UPDATE_LOCK_TYPE=ROW | TABLE | NOLOCK
Syntax Description
- ROW
-
locks a row if any
of its columns are going 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.
See the reference documentation
for your DBMS for additional details.
See Also
To apply this
option to an individual table, use the UPDATE_LOCK_TYPE= data set
option.