Data Set Options for Relational Databases

BL_ROWSETSIZE= Data Set Option

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

Syntax
Syntax Description
Details
See Also

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

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.