Data Set Options for Relational Databases |
Default value: | none |
Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
DBMS support: | HP Neoview |
Syntax | |
Syntax Description | |
Details | |
See Also |
Syntax |
BL_ROWSETSIZE=number-of-records |
specifies the number of records in each batch of rows to exchange with the database.
Details |
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.
See Also |
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.