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

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” (page 66)
• “Help Listing from the Type 4 Lob Admin Utility” (page 67)
• “Creating LOB Tables” (page 67)
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” (page 42).
clobTableName
Specifies the LOB table for CLOB columns. Required if CLOB columns are involved.
See “LOB Table Name Properties” (page 42).
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
Descriptionprog_option
Displays help information-help
Runs the SQL statements that are generated.-exec
Generates SQL statements to create LOB tables. These statements describe the architecture of the
tables and, therefore, provide a description of the LOB tables.
-create
Generates SQL statements to create triggers for the designated table. The base table must exist.-trigger
Generate SQL statements to drop triggers for the designated table. The table must exist.-drop
Writes the SQL statements to a specified file.-out
Generates SQL statements to create unicode LOB tables <CLOB only>.-unicode -
Generates SQL statements to create LOB column size of 24K bytes and attribute block size of 32K.-bigblock
66 Managing the SQL/MX Tables for BLOB and CLOB Data