ROWSET_SIZE=

ROWSET_SIZE=

Specifies the number of rows to use when reading data from the DBMS.

Default value: 0

Syntax
Details

Syntax

ROWSET_SIZE= number-of-rows

Details

By default, ROWSET_SIZE=0, so that no internal SAS buffering is performed. Setting ROWSET_SIZE=0 causes the SQLFetch API call to be used.

When ROWSET_SIZE=1, only one row is retrieved at a time. The higher the value for ROWSET_SIZE=, the more rows the DB2 engine retrieves in one fetch operation. This option reduces the amount of I/O that is used and can help improve performance. However, because SAS software stores the rows in memory, higher values for ROWSET_SIZE= use more memory. In addition, if too many rows are selected at once, then the rows that are returned to the SAS application might be out of date. For example, if someone else modified the rows, you would not see the changes. Setting ROWSET_SIZE=1 or greater causes the SQLExtendedFetch API call to be used.

Chapter Contents
Previous
Next
Top of Page