JDBC Driver for SQL/MX Programmer's Reference

-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 table must exist.

-unicode

Generates SQL statements to create unicode LOB tables.

Use only for CLOB data.

-drop

Generate SQL statements to drop triggers for the

designated table. The table must exist.

-out

Writes the SQL statements to a specified file in OSS file

space.

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 JDBC/MX Lob Admin Utility

The command to display JDBC/MX Lob Admin utility help appears below followed by the help listing.

java JdbcMxLobAdmin -help

Company, LP.

java [<java_options>] JdbcMxLobAdmin [<prog_options>] [<table_name>]

<java_options> is:

[-Djdbcmx.clobTableName=<clobTableName>]

[-Djdbcmx.blobTableName=<blobTableName>]

[-Djdbcmx.catalog=<catalog>]

[-Djdbcmx.schema=<schema>]

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

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