132 UPDATE_MULT_ROWS= LIBNAME Option Chapter 9
Syntax
UPDATE_MODE_WAIT= YES|NO
Syntax Description
YES
specifies for Teradata to wait to acquire the lock, so SAS/ACCESS waits indefinitely
until it can acquire the lock.
NO
specifies for Teradata to fail the lock request if the specified DBMS resource is locked.
Details
If you specify UPDATE_MODE_WAIT=NO and if a different user holds a restrictive
lock, then the executing SAS step fails. SAS/ACCESS continues processing the job by
executing the next step.
A
restrictive lock means that a different user is holding a lock that prevents you from
obtaining your desired lock. Until the other user releases the restrictive lock, you
cannot obtain your lock. For example, another user’s table level WRITE lock prevents
you from obtaining a READ lock on the table.
Use SAS/ACCESS locking options only when Teradata’s standard locking is
undesirable.
For more information, see the documentation for the Teradata interface.
See Also
To apply this option to an individual data set, see the data set option
“UPDATE_MODE_WAIT= Data Set Option” on page 215.
UPDATE_MULT_ROWS= LIBNAME Option
Indicates whether to allow SAS to update multiple rows from a data source, such as a DBMS table
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support: ODBC, OLE DB, Microsoft SQL Server
Default value: NO
Syntax
UPDATE_MULT_ROWS= YES | NO
Syntax Description
YES
