JDBC Type 4 Driver 1.1 Programmer's Reference

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
URL for the Type 4 driver connection. See url Property.
usr
User name for the Type 4 driver connection. See user Property.
password
Password associated with the user. See password Property.
program_options