If you specify UPDATE_MODE_WAIT=NO
and if a different user holds a
restrictive lock,
then your SAS step fails and
SAS/ACCESS continues the job by processing
the next step. If you specify UPDATE_MODE_WAIT=YES,
SAS/ACCESS waits
indefinitely until it can acquire the lock.
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 standard locking is undesirable.
For more information,
see the locking topic in the Teradata section.