Adaptive Server ODBC Driver supports large object (LOB) locators. A LOB locator
contains a logical pointer to LOB data rather than the data itself, reducing the amount of
data that passes through the network between Adaptive Server and its clients.
Adaptive Server ODBC Driver clients cannot use LOB locators unless connected to an Adaptive
Server that supports it. Adaptive Server has server support for LOB locators.
Note:
When you are using LOB locators, retrieving a large result set that includes LOB data on
each row may impact your application's performance. Adaptive Server returns a LOB locator
as part of the result set and, to obtain LOB data, Adaptive Server ODBC Driver must cache
the remaining result set. Sybase recommends that you keep result sets small, or that you
enable cursor support to limit the size of data to be cached.