JDBC Driver for SQL/MX Programmer's Reference

Miscellaneous
NULL and Empty BLOB or CLOB Value●
Transactions Involving Blob and Clob
Access
●
Access Considerations for Clob and Blob
Objects
●
For full working examples showing how to access BLOB and CLOB data, see Appendix A.
For information about creating and managing tables for BLOB and CLOB data, see Managing
the SQL/MX Tables for BLOB and CLOB Data.
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