JDBC Type 4 Driver Programmer's Reference for SQL/MX Release 3.1 (H06.23+, J06.12+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

1. At the OSS prompt, invoke the SQL/MX utility MXCI. Type:

mxci

2. Type the following command to enable creating tables that have LOB columns:

CONTROL QUERY DEFAULT JDBC_PROCESS 'TRUE';

3. Type the CREATE TABLE statement; for example, you might use the following simple form of the statement:

CREATE TABLE table1 (c1 INTEGER NOT NULL, c2 CLOB, c3 BLOB, PRIMARY KEY(c1));

where

table1

The name of the base table.

Note: If different LOB tables are used for storing BLOB or CLOB data, the base table name for a table

with

BLOB or CLOB columns must be unique across all catalogs and schemas. Otherwise, the

driver will give incorrect data to the application in cases where the LOB tables used get

erroneously switched or changed.

Column 1, defined as the INTEGER data type with the NOT NULL constraint.

Column 2, defined as the CLOB data type.

Column 3, defined as the BLOB data type.

PRIMARY KEY

Specifies

c1 as the primary key.

Use this example as the archetype for creating base tables. For information about valid names for tables (

table1) and columns (c1, c2, and c3)

and for information about the CREATE TABLE statement, see the SQL/MX Reference Manual.

Using JDBC Programs To Create Base Tables that Have LOB Columns

When using a JDBC Program to create base tables that have LOB columns, put the CREATE TABLE statements in the program as you would

any other SQL statement. For an example of the CREATE TABLE statement, see the discussion

Using MXCI to Create Base Tables that Have

LOB Columns.

Managing LOB Data by Using the Lob Admin Utility

Running the Lob Admin Utility

Help Listing from the Type 4 Lob Admin Utility

Creating LOB Tables

Use the Lob Admin Utility (T4LobAdmin) for the following tasks:

Creating the LOB table (a table that holds LOB data).

Creating the SQL/MX triggers for the LOB columns in the base tables to ensure that orphan LOB data does not occur in a LOB table.

Note: If you are creating triggers, ensure that the base table that contains the CLOB column or BLOB column has already

been created.

Information about using the Lob Admin Utility is described under these topics.

Running the Lob Admin Utility

Help Listing from the Lob Admin Utility

Using SQL/MX Triggers to Delete LOB Data

Running the Lob Admin Utility

Run the T4LobAdmin utility in the OSS environment.

The format of the command is:

java [java_options] com.tandem.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.

-Dt4sqlmx.properties=properties-file-name