READ_MODE_WAIT=

READ_MODE_WAIT=

Specifies during SAS/ACCESS read 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

READ_MODE_WAIT= YES|NO

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

Details

If you specify READ_MODE_WAIT=NO, and a different user holds a restrictive lock, then the executing SAS step will fail. SAS/ACCESS continues processing the job by executing the next step. If you specify READ_MODE_WAIT=YES, SAS/ACCESS waits indefinitely until it can acquire the lock.

A restrictive lock means that another 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 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