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.
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.
