JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

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
prog_option Description
-help Displays help information
-exec Runs the SQL statements that are generated.
-create Generates SQL statements to create LOB tables. These statements describe the architecture of the tables and,
therefore, provide a description of the LOB tables.
-trigger Generates SQL statements to create triggers for the designated table. The base table must exist.
-drop Generate SQL statements to drop triggers for the designated table. The table must exist.
-out Writes the SQL statements to a specified file.
-unicode - Generates SQL statements to create unicode LOB tables <CLOB only>.
-
bigblock Generates SQL statements to create LOB column size of 24K bytes and attribute block size of 32K.
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 SQL/MX 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 6.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>