DB2 Version 9.7 for Linux, UNIX, and Windows

AppUsesLOBLocator CLI/ODBC configuration keyword

Specifies whether applications use LOB locators.

db2cli.ini keyword syntax:

AppUsesLOBLocator = 0 | 1

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 the SQLFetch() function.