Row count (-ROWCNT) adapter command for DB2 (z/OS ODBC)
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
- 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 may be gained by retrieving as many rows as possible in a single fetch.
The default for the number of rows to be retrieved per fetch for the DB2® (z/OS® ODBC) Adapter is one row.