Row Count (-ROWCNT)

Use the Row Count adapter command (-ROWCNT) to specify the number of rows to be retrieved per fetch.

-ROWCNT row_count

Option

Description

row_count

This is the number of rows to be retrieved per fetch.

The time to fetch is optimized in accordance with the increase in the number of rows to retrieve. Therefore, a significant performance improvement might be gained by retrieving as many rows as possible in a single fetch.

The number of rows retrieved is limited only by the amount of memory installed on the querying PC.

The default for the number of rows to be retrieved per fetch for the ODBC Adapter is one row.