JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

LOB Architecture: Tables for LOB Data Support
Types of LOB Table
The LOB table is a separate table from the base table that stores the LOB data. The two types of LOB
table are: Binary or ASCII LOB and Unicode LOB.
The Binary or ASCII LOB table structure is:
table_name CHAR(128) NOT NULL NOT DROPPABLE,
data_locator LARGEINT NOT NULL NOT DROPPABLE,
chunk_no INT NOT NULL NOT DROPPABLE,
lob_data VARCHAR(3880)
The Unicode LOB table structure for ASCII data is:
table_name CHAR(128),
data_locator LARGEINT,
chunk_no INTEGER,
lob_data VARCHAR(1955) CHARACTER SET UCS2
Setting Properties for the LOB Table
Specifying the LOB Table
Reserving Data Locators
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 Lob Admin Utility.
The JDBC applications that access BLOB or CLOB data must specify the associated LOB table names