![](https://pdfstore-manualsonline.prod.a.ki/pdfasset/b/da/bda6fccb-b246-43e7-a520-a01ed647b8cf/bda6fccb-b246-43e7-a520-a01ed647b8cf-bgda.png)
208 READBUFF= Data Set Option Chapter 10
Syntax Description
YES
specifies that Teradata waits to acquire the lock, and SAS/ACCESS waits indefinitely
until it can acquire the lock.
NO
specifies that Teradata fails the lock request if the specified DBMS resource is locked.
Details
If you specify READ_MODE_WAIT=NO, and a different user holds a restrictive lock,
then the executing SAS step fails. SAS/ACCESS continues to process 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 example, another user’s table-level WRITE lock prevents
you from obtaining a READ lock on the table.
For more information, see the SAS/ACCESS documentation for Teradata .
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “READ_MODE_WAIT= LIBNAME Option” on page 120.
READBUFF= Data Set Option
Specifies the number of rows of DBMS data to read into the buffer
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 UNIX/PC, ODBC, OLE DB, Oracle, Microsoft SQL Server, SYBASE
Default value:
LIBNAME setting
Syntax
READBUFF=integer
Syntax Description
integer
is the maximum value that is allowed by the DBMS.
Details
This option improves performance by specifying a number of rows that can be held in
memory for input into SAS. Buffering data reads can decrease network activities and