Neoview JDBC Type 4 Driver Programmer's Reference (R2.2, R2.3, R2.4, R2.5)

Running the Lob Admin Utility
Run the T4LobAdmin utility from the workstation. The format of the command is:
java [java_options] com.hp.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.
-Dhpt4jdbc.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 43).
clobTableName
Specifies the LOB table for CLOB columns. Required if CLOB columns are
involved. See “LOB Table Name Properties” (page 43).
url
URL for the Type 4 driver connection. See “url Property” (page 50).
usr
User name for the Type 4 driver connection. See “user Property” (page 50).
password
Password associated with the user. See “password Property” (page 46).
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
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 Neoview SQL Reference Manual.
Help Listing From the Type 4 Lob Admin Utility
To display help for the Type 4 Lob Admin Utility, type:
java com.hp.t4jdbc.T4LobAdmin -help
Managing LOB Data by Using the Lob Admin Utility 61