JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

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
Running the Lob Admin Utility
Help Listing from the Type 4 Lob Admin Utility
Creating LOB Tables
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.
Note:
If you are creating triggers, ensure that the base table that contains the CLOB column or BLOB column
has already been created.
●
Information about using the Lob Admin Utility is described under these topics.
Running the Lob Admin Utility●
Help Listing from the Lob Admin Utility●
Using SQL/MX Triggers to Delete LOB Data●
Running the Lob Admin Utility
Run the T4LobAdmin utility in the OSS environment.
The format of the command is:
java [java_options] com.tandem.t4jdbc.T4LobAdmin [prog_options] [table_name]
java_options
The java_options should specify the Type 4 driver properties in a properties file on the java command line in the
-D option.
-Dt4sqlmx.properties=properties-file-name
where the properties file should include the following Type 4 driver properties, as applicable:
blobTableName
Specifies LOB table for BLOB columns. Required if BLOB columns are involved. See LOB Table Name
Properties.
clobTableName
Specifies the LOB table for CLOB columns. Required if CLOB columns are involved. See LOB Table Name
Properties.
url