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

Reviewing and Setting System Defaults
HP NonStop SQL/MX Installation and Management Guide—544536-007
6-8
Alternative Settings For Selected System Defaults
HIST_SCRATCH_VOL For SQL/MX
tables, the
default is a
blank. If you do
not set this
value, NonStop
SQL/MX uses
the default
volume specified
by the
_DEFAULTS
define for
SQL/MX tables
and the volume
of the table’s
primary partition
for SQL/MP
tables.
Any disk volume to be used tor
UPDATE STATISTICS temporary
files.
For more information about changes
to this system default, see the
SQL/MX Reference Manual.
NAMETYPE The default
value is ANSI.
The value NSK is appropriate if the
system uses physical Guardian
names (NSK). The NSK setting
applies to the resolution of
unqualified SQL/MP object names.
NATIONAL_CHARSET The default
value is UCS2.
The value ISO88591 is appropriate
if ISO88591 is the preferred national
character set.
A value for NATIONAL_CHARSET
is set when you run the
InstallSqlmx script during
installation of NonStop SQL/MX.
This value can be changed only by
reinstalling NonStop SQL/MX. For
more information, see Section 3,
Installing NonStop SQL/MX.
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
The default
value is OFF.
The value ON means that, by
default, a NOT NULL column
constraint is DROPPABLE.
PRESERVE_MIN_SCALE The default
value is 0.
A value from 0 to 18 specifies the
minimum scale for the result of an
arithmetic operation when the
precision exceeds 18.
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
The default
value is OFF.
The value ON means that, by
default, a PRIMARY KEY column
constraint is DROPPABLE.
Table 6-4. Alternative Settings for Selected System Defaults (page2of6)
System Default Default Value Alternative Setting