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

table_name
The table_name represents a base table that contains LOB columns. The table_name is of the form:
[catalogName.][schemaName.]baseTableName
For information about catalog, schema, and table names, see the HP NonStop SQL/MX Release
3.2.1 Reference Manual.
Help Listing from the Type 4 Lob Admin Utility
To display help for the Type 4 Lob Admin Utility, type:
java -Dt4sqlmx.properties=t4lob.prop com.tandem.t4jdbc.T4LobAdmin -help
Example 4 Example 1. Type 4 Lob Admin Utility Help
Hewlett-Packard T4 Lob Admin Utility 1.0
(c) Copyright 2004 Hewlett-Packard Development Company, LP.
java [<java_options>] T4LobAdmin [<prog_options>] [<table_name>]
<java_options> is:
[-Dt4sqlmx.properties=<properties file>]
where <properties file> has values for the following:
clobTableName - CLOB table name
blobTableName - BLOB table name
url - URL used for the Type 4 connection
user - User name for the Type 4 connection
password - Password for associated with the user
<prog_options> is:
[-exec] [-create] [-trigger][-unicode] [-spj] [-help] [-drop] [-out <filename>] [-bigblock]
where -help - Display this information.
-exec - Execute the SQL.
-create - Generate SQL statements to create LOB tables.
-trigger - Generate SQL statements to create triggers for <table_name>.
-unicode - Generate SQL statements to create unicode LOB tables <CLOB only>.
-drop - Generate SQL statements to drop triggers for <table_name>.
-out - Write the SQL statements to <filename>.
-spj - Generate SQL statements to create and execute tables for SPJ LOB usage.
-bigblock- Generates SQL statements to create LOB column size of 24K bytes and
attribute block size of 32K.
<clobTableName> | <blobTableName> is:
<catalogName>.<schemaName>.<lobTableName>
<table_name> is:
[<catalogName>.][<schemaName>.]<baseTableName>
<baseTableName> is the table that contains LOB column(s). TableName> is the table that contains the LOB data.
Creating LOB Tables
Except as noted in the following, use the -create and -execute options of the Lob Admin Utility
to create LOB tables.
NOTE: Partitioned LOB tables must be manually created. You cannot use the Lob Admin Utility
if your site needs partitioned LOB tables. Do not use the -execute option of the Lob Admin
Utility. Follow these steps to manually create partitioned LOB tables:
1. Use the -create and -out options of the Lob Admin Utility to have SQL statements written
to a file.
2. Modify the generated SQL statements as needed for your partitioning requirements.
3. Add the modified SQL statements to an MXCI script file.
4. Move the MXCI script file to the OSS environment, and run it.
Using SQL/MX Triggers to Delete LOB Data
Use the Type 4 Lob Admin Utility to generate triggers that delete LOB data from the LOB table
when the base row is deleted. These triggers ensure that orphan LOB data does not occur in the
LOB table. To manage the triggers, use these Type 4 Lob Admin Utility options:
-trigger
Generates SQL statements to create triggers.
Using SQL/MX Triggers to Delete LOB Data 67