Data Set Options for Relational Databases |
Specifies the number of records
to exchange with the database.
Default value: |
none
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
HP Neoview
|
BL_ROWSETSIZE=number-of-records
|
- number-of-records
-
specifies the number of records in each batch of rows to
exchange with the database.
To specify this option, you must first set BULKEXTRACT=YES.
The value for this option must be an integer from 1 to 100,000. If you
do not specify this option, an optimized value is chosen based on the SQL
table or query.
Enter 0 to disable this option. This option is ignored for
extraction.
BULKEXTRACT= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.