AppUsesLOBLocator CLI/ODBC and IBM data server driver configuration keyword
Specifies whether applications use LOB locators.
- db2cli.ini keyword syntax:
- AppUsesLOBLocator = 0 | 1
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="AppUsesLOBLocator" 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:
- Applications are using LOB locators.
- Equivalent connection or statement attribute:
- SQL_ATTR_APP_USES_LOB_LOCATOR
- Usage notes:
- The default setting of 1 indicates that applications are using LOB locators. For applications
that do not use LOB locators and are querying data on a server that supports Dynamic Data Format,
also known as progressive streaming, specify 0 to indicate that LOB locators are not used and allow
the return of LOB data to be optimized.
This keyword is ignored for stored procedure result sets.
If the keyword is set to 0 and an application binds a LOB locator to a result set using
SQLBindCol(), an Invalid conversion error will be returned by theSQLFetch()function.