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

Example 6-1 Type 4 Lob Admin Utility Help

Hewlett-Packard T4 Lob Admin Utility 1.0

java [<java_options>] com.hp.t4jdbc.T4LobAdmin [<prog_options>] [<table_name>]

<java_options> is:

[-Dhpt4jdbc.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.

Creating LOB Tables

Except as noted below, 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 a Neoview script file.

4. Run the script file from Neoview Script by using obey command.

Using SQL Triggers to Delete LOB Data

Use the Type 4 Lob Admin Utility to generate triggers on SQL tables 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.

-drop

Generates SQL statements to drop triggers.

-exec

Executes the SQL statements that are generated.

62 Managing the SQL Tables for BLOB and CLOB Data