JDBC Driver for SQL/MX Programmer's Reference

Home | Contents | Prev | Next | Index | Glossary
Managing the SQL/MX Tables for BLOB and
CLOB Data
BLOB and CLOB are not native data types in an SQL/MX database. But, database administrators can create
SQL/MX tables that have BLOB and CLOB columns by using the JDBC/MX driver or special SQL syntax in
MXCI as described in this section. For management purposes, CLOB and BLOB data is referred to as large object
(LOB) data, which can represent either data type.
Note: Support for BLOB and CLOB data requires SQL/MX tables.
Before using this section, be sure to see the file descriptions for the tables that contain LOB data. This information
is under the topic Architecture for LOB Support in the preceding section.
With the exception above, this section provides the information that database administrators need to create and
manage the tables required to support LOB data. The topics are:
Creating Base Tables that Have LOB Columns●
Managing LOB Data by Using the JDBC/MX Lob Admin Utility●
Using SQL/MX Triggers to Delete LOB Data●
Limitations of the BLOB and CLOB Data Types●
Creating Base Tables that Have LOB
Columns
You can write JDBC programs to create base tables that have LOB columns or you can use the SQL/MX
conversational interface MXCI as described in the following topics:
Data Types for LOB Columns●
Using MXCI to Create Base Tables that Have LOB Columns●
Using JDBC Programs to Create Base Tables that Have LOB Columns●
Data Types for LOB Columns
The data types for the LOB columns are:
CLOB
Character large object data
BLOB
Binary large object data
Note: The CLOB and BLOB data type specification is special syntax that is allowed for use in base
tables accessed by JDBC/MX driver as described in this manual.