PromoteLONGVARtoLOB CLI/ODBC and IBM data server driver configuration keyword
Promotes LONGVARxxx data types to xLOB data types.
- db2cli.ini keyword syntax:
- PROMOTELONGVARTOLOB = 0 | 1
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="PromoteLONGVARtoLOB" value="0 | 1"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- 0
- Usage notes:
-
This option should only be used when a LONGVARxxxx value has the potential to exceed 32K. The return type of the column is promoted to xLOB to hold the larger data size.