JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

Chapter 6. Managing the SQL/MX Tables for BLOB and CLOB Data
Prev Next
Chapter 6. Managing the SQL/MX Tables for BLOB and CLOB
Data
Before You Begin Managing LOB Data
Creating Base Tables that Have LOB Columns
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
Managing LOB Data by Using the Lob Admin Utility
Running the Lob Admin Utility
Help Listing from the Type 4 Lob Admin Utility
Creating LOB Tables
Using SQL/MX Triggers to Delete LOB Data
Backing Up and Restoring LOB Columns
Limitations of LOB Data (CLOB and BLOB Data Types)
This chapter describes the creation and management of the tables required to support LOB data for database administrators.
Before You Begin Managing LOB 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 Type 4 driver or special SQL syntax in MXCI as described in this chapter. For management purposes, CLOB and BLOB
data is referred to as large object (LOB) data, which can represent either data type.
Before reading this chapter, also read Architecture for LOB Support, which describes the files for the tables that contain LOB data.
Creating Base Tables that Have LOB Columns
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
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 this chapter.
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 the
Type 4 driver described in this manual.
Using MXCI To Create Base Tables that Have LOB Columns
Before using the procedure to create the tables, note that when using MXCI to create base tables, you must enter the following special
command in the MXCI session to enable the base-table creation of tables that have LOB (
BLOB or CLOB) columns:
CONTROL QUERY DEFAULT JDBC_PROCESS 'TRUE'
Follow these steps to create a base table that has LOB columns: