JDBC Type 2 Driver 3.0 Programmer's Reference (SQL/MX 3.x)

Architecture for LOB Support
The tables that support LOB data are:
Base table
Referenced by JDBC applications to insert, store, read, and update BLOB and CLOB data. In the base table, the
JDBC/MX driver maps the BLOB and CLOB columns into a data-locator column. The data-locator column points
to the actual LOB data that is stored in a separate user table called the LOB table.
LOB table
Actually contains the BLOB and CLOB data in chunks. A Clob or Blob object is identified by a data locator. LOB
tables have two formats: LOB table for BLOB data and a LOB table for CLOB data.
LOB Architecture: Tables for LOB Data Support
Setting Properties for the LOB Table
Before running the JDBC application that uses BLOB and CLOB data through the JDBC API, the database
administrator must create the LOB tables. For information on creating LOB tables, see Managing LOB Data with the
JDBC/MX Lob Admin Utility.
The JDBC applications that access BLOB or CLOB data must specify the associated LOB table names and, optionally,
configure the reserveDataLocator property. These tasks are described in the topics:
Specifying the LOB Table
Reserving Data Locators
Specifying the LOB Table
At run time, a user JDBC application notifies the JDBC/MX driver of the name, or names, of the LOB tables
associated with the CLOB or BLOB columns of the base tables being accessed by the application. One LOB table, or
separate tables, can be used for BLOB and CLOB data.
The JDBC application specifies a LOB table name either through a system parameter or through a Java Property