SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-46
Module Management
Module Management
This attribute determines where globally placed modules are generated:
National Character Set
This attribute determines the default for the national character set:
For information about the use of the N'string' literal, see Character String Literals
on page 6-62.
For information about the use of the NCHAR keyword, see Character String Data Types
on page 6-20.
For a description of available character sets, see Character Sets on page 6-3.
Attribute Setting
MXCMP_PLACES_LOCAL_
MODULES
Set to ON or OFF.
If OFF, NonStop SQL/MX generates global modules in
the USERMODULES directory.
If ON and you do not specify
mxcmp -g moduleLocal=OSS-dir
on the command line, compiled modules are placed in
the current OSS directory.
If ON and you specify
mxcmp -g moduleLocal=OSS-dir
on the command line, compiled modules are placed in
the OSS-dir directory.
The default is OFF.
For more information about module management, see
the SQL/MX Programming Manual for C and COBOL.
Attribute Setting
NATIONAL_CHARSET Displays the national character set ISO88591, UCS2,
KANJI, or KSC5601 used in NCHAR and NCHAR
VARYING columns. The national character set also
governs the interpretation of the character string literal
N'string.'
You select the national character set when you install
NonStop SQL/MX by using the -n option of the
InstallSqlmx script. If you specify KANJI or
KSC5601 and later attempt to create an SQL/MX table
with an NCHAR column, you will receive an error
message 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.
For more information about setting the national
character set from the InstallSqlmx script, see the
SQL/MX Installation and Management Guide.