Data Set Options for Relational Databases |
Specifies
the number of rows of DBMS data to read into the buffer.
Alias: |
ROWSET_SIZE= [DB2 under UNIX and PC Hosts, Microsoft
SQL Server, Netezza, ODBC, OLE DB]
|
Default value: |
LIBNAME setting
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
Aster nCluster, DB2 under
UNIX and PC Hosts, DB2 under z/OS,
Greenplum, HP Neoview, Microsoft SQL Server, Netezza, ODBC, OLE DB, Oracle,
Sybase, Sybase IQ
|
-
integer
-
is the maximum value that is allowed by
the DBMS.
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 increase performance. However,
because SAS stores the rows in memory, higher values for READBUFF= use more
memory. In addition, if too many rows are selected at once, then the rows
that are returned to the SAS application might be out of date.
When READBUFF=1, only one row is retrieved at a time.
The higher the value for READBUFF=, the more rows the SAS/ACCESS engine
retrieves in one fetch operation.
DB2 under UNIX and PC Hosts: By default,
the SQLFetch API call is used and no internal SAS buffering is performed.
Setting READBUFF=1 or greater causes the SQLExtendedFetch API call to be
used.
Greenplum, Microsoft SQL Server, Netezza, ODBC,
Sybase IQ: By default, the SQLFetch API call is used and no internal
SAS buffering is performed. Setting READBUFF=1 or greater causes the SQLExtendedFetch
API call to be used.
To assign this option to a group of relational
DBMS tables or views, see the READBUFF= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.