UPDATE_MODE_WAIT=

UPDATE_MODE_WAIT=

Specifies during SAS/ACCESS update operations whether Teradata should wait to acquire a lock or fail your request when the DBMS resource is locked by a different user.

Default value: None

Syntax
Details

Syntax

UPDATE_MODE_WAIT= YES|NO

YES: specifies that SAS/ACCESS should wait to acquire a lock for an update operation if a different user holds a restrictive lock.
NO: specifies that SAS/ACCESS should not wait.

Details

If you specify UPDATE_MODE_WAIT=NO, and a different user holds a restrictive lock, then your SAS step will fail and SAS/ACCESS will continue 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.

Use SAS/ACCESS locking options only when Teradata's standard locking is undesirable. For more information, see the LOCKING modifier in your Teradata SQL Reference manual, as well as Understanding the Scope of SAS/ACCESS Lock Options.

Chapter Contents
Previous
Next
Top of Page