IBM InfoSphere Federation Server, Version 10.1

LOB locators

Applications can request LOB locators for LOBs that are stored in remote data sources. A LOB locator is a 4-byte value stored in a host variable. An application can use the LOB locator to refer to a LOB value (or LOB expression) held in the database system.

Using a LOB locator, an application can manipulate the LOB value as if the LOB value was stored in a regular host variable. When you use LOB locators, there is no need to transport the LOB value from the data source server to the application (and possibly back again).

The federated database can retrieve LOBs from remote data sources, store them at the federated server, and then issue a LOB locator on the stored LOB. LOB locators are released when:
  • Applications issue FREE LOCATOR SQL statements
  • Applications issue COMMIT statements
  • The federated instance is restarted
Parent topic: Federated LOB support
Related concepts:
Restrictions on LOBs

Feedback

Update icon Last updated: 2012-05-18