MaxBlkExt CLI/ODBC and IBM data server driver configuration keyword
A 32-bit integer value that is used to set the maximum number of extra query blocks returned by a Db2 server for a result set.
- db2cli.ini keyword syntax:
- MaxBlkExt = 0 | ... | 100
- IBM data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="MaxBlkExt" value="0 | ... | 100"/>
- Default setting:
- 0
- Equivalent connection or statement attribute:
- SQL_ATTR_MAXBLKEXT
- Usage notes:
- Set this keyword only when none of the following are set:
- The OptimizeForNRows keyword
- The BlockForNRows keyword
- The NumRowsOnFetch keyword
- The SQL_MAX_ROWS attribute