JDBC Type 4 Driver 1.1 Programmer's Reference

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.
Note:
Support for BLOB and CLOB data requires SQL/MX tables.
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