MX 2.x)

The default catalog and schema are used to access SQL objects referenced in SQL statements if the SQL objects are

not fully qualified. The three-part fully qualified name for SQL/MX objects is of the form:

[[catalog.]schema.]object-name

The catalog and schema names can be any arbitrary strings that conform to SQL identifiers. These names conform to

ANSI SQL:99 catalog and schema names.

For example, using the default catalog and schema properties for a table referenced as CAT.SCH.TABLE, the options are:

-Djdbcmx.catalog=CAT -Djdbcmx.schema=SCH

For more information, see the SQL/MX Reference Manual.

LOB Table Name Properties

LOB tables store data for LOB columns. The properties you use to specify the LOB table for using BLOB columns or

CLOB columns are:

For the BLOB columns

blobTableName

For the CLOB columns

clobTableName

The property value is of the form:

catalog_name.schema_name.lob_table_name

You can specify the name of the LOB table using properties in the following ways:

By using the –Djdbcmx.property_name=property_value option in the java command line. For example:

–Djdbcmx.clobTableName=mycat.myschema.myLobTable

By using the java.util.Properties parameter in the getConnection method of DriverManager class. The

properties passed through the Properties parameter have precedence over the command line properties.

By setting either of these properties in the DataSource. See Connection Using the DataSource Implementation.

ISO88591 Property

The ISO88591 character set mapping property corresponds to the SQL/MX ISO88591 character set, which is a single-

byte 8-bit character set for character data types. The ISO88591 character set supports English and other Western

European languages. Specify the ISO88591 property as

String

The default value is DEFAULT which uses the default Java encoding when accessing and writing to ISO88591 columns.

The value can be any valid Java Canonical Name as listed in the "Canonical Name for java.io and java.lang API"

column of the Sun documentation, Supported Encodings

(http://java.sun.com/j2se/1.5.0/docs/guide/intl/encoding.doc.html).

For example, if KANJI data has been stored in an ISO88591 column in an SQL/MP table (accessed through SQL/MX)

and has been read and written to the database using the column character set, you can specify the following property to

ensure the correct encoding:

-Djdbcmx.ISO88591=SJIS