Data Set Options for Relational Databases READ_MODE_WAIT= Data Set Option 207
Syntax Description
Not all values are valid for every interface. See details below.
ROW
locks a row if any of its columns are accessed. (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. If you specify READ_LOCK_TYPE=TABLE, you must
also specify the LIBNAME option CONNECTION=UNIQUE, or you will receive an
error message. Setting CONNECTION=UNIQUE ensures that your table lock is not
lost, for example, due to another table closing and committing rows in the same
connection. (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, pages, or any rows during a read transaction. (This
value is valid in the Oracle and SYBASE interfaces, in the ODBC and Microsoft SQL
Server interfaces when using the Microsoft SQLServer driver, and in the OLE DB
interface when using the Microsoft SQLServer provider.)
VIEW
locks the entire DBMS view. (This value is valid in the Teradata interface.)
Details
If you omit READ_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.
See the documentation for your SAS/ACCESS interface for additional details.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “READ_LOCK_TYPE= LIBNAME Option” on page 119.
READ_MODE_WAIT= Data Set Option
Specifies during SAS/ACCESS read operations whether Teradata 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
READ_MODE_WAIT= YES|NO
