JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.2.1

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:
1. At the OSS prompt, enter the following to invoke the SQL/MX utility MXCI:
mxci
2. Type the following command to enable creating tables that have LOB columns:
CONTROL QUERY DEFAULT JDBC_PROCESS 'TRUE';
3. Type the CREATE TABLE statement; for example, you might use the following simple form of
the statement:
CREATE TABLE table1 (c1 INTEGER NOT NULL, c2 CLOB, c3 BLOB, PRIMARY
KEY(c1));
where
table1
The name of the base table.
NOTE: If different LOB tables are used for storing BLOB or CLOB data, the base table name for
a table with BLOB or CLOB columns must be unique across all catalogs and schemas. Otherwise,
the driver will give incorrect data to the application in cases where the LOB tables used get
erroneously switched or changed.
c1
Column 1, defined as the INTEGER data type with the NOT NULL constraint.
c2
Column 2, defined as the CLOB data type.
c3
Column 3, defined as the BLOB data type.
PRIMARY KEY
Specifies c1 as the primary key.
Use this example as the archetype for creating base tables. For information about valid names for
tables (table1) and columns (c1, c2, and c3) and for information about the CREATE TABLE
statement, see the HP NonStop SQL/MX Release 3.2.1 Reference Manual.
Using JDBC Programs To Create Base Tables that Have LOB Columns
When using a JDBC Program to create base tables that have LOB columns, put the CREATE TABLE
statements in the program as you would any other SQL statement. For an example of the CREATE
TABLE statement, see the discussion Using MXCI to Create Base Tables that Have LOB Columns.
Managing LOB Data by Using the Lob Admin Utility
Use the Lob Admin Utility (T4LobAdmin) for the following tasks:
• Creating the LOB table (a table that holds LOB data).
• Creating the SQL/MX triggers for the LOB columns in the base tables to ensure that orphan
LOB data does not occur in a LOB table.
Managing LOB Data by Using the Lob Admin Utility 65