QueryPrefetch IBM data server driver 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.
- Equivalent CLI keyword
- QueryPrefetch
- Equivalent IBM® data server provider for .NET connection string keyword
- SQL_ATTR_QUERY_PREFETCH
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="QueryPrefetch" value="0 | 1"/>- Default setting:
- 0
- Usage notes:
-
This option enables prefetching of multiple query blocks for a forward only blocked cursor.