SQL/MX 3.2 Management Manual (H06.25+, J06.14+)

Table 6 Settings for Selected System Defaults (page 1 of 5) (continued)
Alternative SettingDefault ValueSystem Default
The value ISO88591 is appropriate if ISO88591 is
the preferred national character set.
The default value is UCS2.NATIONAL_CHARSET
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 SQL/MX Installation and Upgrade
Guide.
The value ON means that, by default, a NOT NULL
column constraint is DROPPABLE.
The default value is OFF.NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
A value from 0 to 18 specifies the minimum scale
for the result of an arithmetic operation when the
precision exceeds 18.
The default value is 0.PRESERVE_MIN_SCALE
The value ON means that, by default, a PRIMARY
KEY column constraint is DROPPABLE.
The default value is OFF.PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
The value 0 deactivates the query cache in the current
session.
The default value is 1024.QUERY_CACHE
A very large value means that all the cache entries
could be displaced to accommodate one very large
The default value is 10.QUERY_CACHE_MAX_ VICTIMS
query. A value of 0 means that, when the cache
becomes full, no cache entries (pinned or unpinned)
can be displaced, and no new entries can be entered
into the cache.
A value greater than the number of columns in a
composite key indicates all columns of the key are
The default value is 255.QUERY_CACHE_REQUIRED_
PREFIX_KEYS
required. The value 0 means that the presence of
any one column of a composite primary or partition
key in an equality key predicate is sufficient to make
that predicate cacheable. A value greater than zero
but less than the number of columns in the key
indicates that the first n columns of the key must be
present in a key predicate for that predicate to be
considered cacheable.
The value CLEAR means that all subsequent query
cache entries are unpinned, and all pinned entries
The default value is OFF.QUERY_CACHE_
STATEMENT_PINNING
in the cache are also unpinned. The value ON means
that all subsequent query cache entries into the cache
are pinned.
The value ON means that NonStop SQL/MX
generates a warning when a statement is
The default value is OFF.RECOMPILATION_WARNINGS
automatically recompiled in an application (because
of various factors). A warning is also generated when
a similarity check passes. Set this default to ON only
if your application needs to receive warning
messages when automatic recompilations take place,
or if it needs to know if a similarity check has passed.
When automatic recompilation occurs, NonStop
SQL/MX always logs an EMS event regardless of
the setting of this CQD.
The value OFF means that NonStop SQL/MX will
not generate this warning.
This default affects the behavior of a new referential
constraint specified with NO ACTION.
The default value is SYSTEM.REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT
OFF means that SQL issues error 1301; SYSTEM
means that SQL issues warning 1302 saying that it
System Default Settings to Review After Installing Current Release of SQL/MX 69