BL_ROWSETSIZE= Data Set Option

Specifies the number of records to exchange with the database.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default: none
Restriction: This option is ignored for extraction.
Requirement: To specify this option, you must first set BULKEXTRACT= YES or BULKLOAD=YES. Enter 0 to disable this option.
Data source: HP Neoview
See: BULKEXTRACT= data set option, BULKLOAD= data set option

Syntax

BL_ROWSETSIZE=number-of-records

Syntax Description

number-of-records
specifies the number of records in each batch of rows to exchange with the database.

Details

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.