JDBC Type 2 Driver Programmer's Reference for SQL/MX Release 3.2.1 (H06.26+, J06.15+)

java_options
The java_options are properties that can be specified on the java command line in the -D option.
DescriptionProperty Specification
Specifies the LOB table for using BLOB columns. Required if BLOB columns are
involved. See “LOB Table Name Properties” (page 26).
jdbcmx.blobTableName
Specifies the LOB table for using CLOB columns. Required if CLOB columns are
involved. See “LOB Table Name Properties” (page 26).
jdbcmx.clobTableName
Sets the default catalog. See “Default Catalog and Schema” (page 26).jdbcmx.catalog
Sets the default schema. See “Default Catalog and Schema” (page 26).jdbcmx.schema
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 table must
exist.
-trigger
Generates SQL statements to create unicode LOB tables. Use only for CLOB data.-unicode
Generate SQL statements to drop triggers for the designated table. The table must
exist.
-drop
Writes the SQL statements to a specified file in OSS file space.-out
Generates SQL statements to create LOB column size of 24K bytes and attribute block
size of 32K.
-bigblock
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
Hewlett-Packard JDBC/MX Lob Admin Utility 2.0 (c) Copyright 2004, 2005 Hewlett-Packard
Development 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] [-unicode] [-help] [-drop] [-out <filename>][-bigblock]
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>.
56 Managing the SQL/MX Tables for BLOB and CLOB Data