SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Installing NonStop SQL/MX

HP NonStop SQL/MX Installation and Management Guide—544536-007

3-22

InstallSqlmx Error Messages

For information about the non-SQLCODE error messages generated by

InstallSqlmx, see the SQL/MX Messages Manual.

-l volume Use this option to specify the volume in which

InstallSqlmx installs SQL/MX system metadata tables.

The volume, which must be audited, should not go on

$SYSTEM.

InstallSqlmx determines whether system metadata

tables already exist. If they already exist, an error message

appears and InstallSqlmx terminates. See the

InstallSqlmx error message information in the SQL/MX

Messages Manual for more information.

You must always specify the -l option first in the

InstallSqlmx script command line.

-n

national_charset_name

Use this option to specify the name of the national character

set for NCHAR/NCHAR VARYING. The value for the -n

option can be ISO88591, UCS2, KANJI, or KSC5601.

However, if you specify KANJI or KSC5601 and later

attempt to create an SQL/MX table with an NCHAR column,

you receive an error message and the operation fails

because SQL/MX tables do not support the KANJI or

KSC5601 character sets.

If you do not specify a value for the -n option, the national

character set defaults to UCS2.

-nofcheck Use this option to specify that FCHECK should not be

performed on local volumes to locate SQL/MP tables with

added columns. If this option is not specified,

InstallSqlmx automatically performs FCHECK.

Table 3-3. InstallSqlmx Command Options (page 2 of 2)

Option Description