A SERVICE OF

logo

Data Set Options for Relational Databases UPDATE_MODE_WAIT= Data Set Option 215
Syntax Description
Not all values are valid for every interface. See details below.
ROW
locks a row if any of its columns are going to be updated. (This 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 is valid in the
SYBASE interface.)
TABLE
locks the entire DBMS table. (This 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 is valid in the Microsoft SQL Server, ODBC, Oracle and SYBASE interfaces.)
VIEW
locks the entire DBMS view. (This is valid in the Teradata interface.)
Details
If you omit UPDATE_LOCK_TYPE=, you get either the default action for the DBMS
that you are using, or a lock for the DBMS that was set with the LIBNAME statement.
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.
For more information, see the documentation for your SAS/ACCESS interface.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “UPDATE_LOCK_TYPE= LIBNAME Option” on page 130.
UPDATE_MODE_WAIT= Data Set Option
Specifies during SAS/ACCESS update operations whether the DBMS waits to acquire a lock or fails
your request when the DBMS resource is locked by a different user
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: Teradata
Default value:
LIBNAME setting
Syntax
UPDATE_MODE_WAIT= YES|NO
Syntax Description