JDBC Type 4 Driver 2.0 Programmer's Reference (SQL/MX 2.x)

[-exec] [-create] [-trigger][-unicode] [-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>.

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

<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:

Use the -create and -out options of the Lob Admin Utility to have SQL statements written to a file.1.

Modify the generated SQL statements as needed for your partitioning requirements.2.

Add the modified SQL statements to an MXCI script file.3.

Move the MXCI script file to the OSS environment, and run it.4.

Using SQL/MX Triggers to Delete LOB Data

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

For example, the following command generates the SQL statements to create the triggers for the base table

sales.paris.pictures, which contains a BLOB column, and executes those statements. Note: This command must

be typed on one line.

java -Dt4sqlmx.blobTableName=sales.paris.lobTable4pictures

com.tandem.t4jdbc.T4LobAdmin

-trigger