The LIBNAME Statement for Relational Databases

READ_MODE_WAIT= LIBNAME Option

Specifies during SAS/ACCESS read operations whether Teradata should wait to acquire a lock or should fail the request when a different user has already locked the DBMS resource.

Default value:	none
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Teradata

Syntax
Syntax Description
Details
See Also

Syntax

READ_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 READ_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. For more information, see Locking in the Teradata Interface.

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 the lock that you want. 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.