QueryPrefetch CLI/ODBC configuration keyword
Enables prefetch multiple query blocks when SQLFetch() API is used for blocked cursors only.
Attention: This keyword is available in Db2 11.5.6 and later versions.
- db2cli.ini keyword syntax:
- QUERYPREFETCH = 0 | 1
- Default setting:
- 0
- Equivalent connection or statement attribute:
- SQL_ATTR_QUERY_PREFETCH
- Usage notes:
- This option enables prefetching of multiple query blocks for a forward-only blocked cursor.