Previous Page | Next Page

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.


See Also

BULKEXTRACT= Data Set Option

Previous Page | Next Page | Top of Page