JDBC Type 4 Driver 1.1 Programmer's Reference

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.

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 com.tandem.t4jdbc.T4LobAdmin -help

Example 6.1. Type 4 Lob Admin Utility Help

Hewlett-Packard T4 Lob Admin Utility 1.0

java [<java_options>] com.tandem.t4jdbc.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] [-help] [-drop] [-out <filename>]

where -help - Display this information.

-exec - Execute the SQL statements that are generated.

-create - Generate SQL statements to create LOB tables.

-trigger - Generate SQL statements to create triggers for <table_name>.

-drop - Generate SQL statements to drop triggers for <table_name>.

-out - Write the SQL statements to <filename>.

<clobTableName> | <blobTableName> is:

<table_name> is:

[<catalogName>.][<schemaName>.]<baseTableName>

<baseTableName> is the table that contains LOB column(s). TableName> is the table

that contains the LOB data.