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-10
Alternative Settings For Selected System Defaults
RECOMPILATION_WARNINGS The default
value is OFF.
The value ON means that NonStop
SQL/MX generates a warning when
a statement is 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.
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT
The default
value is
SYSTEM.
This default affects the behavior of a
new referential constraint specified
with NO ACTION.
OFF means that SQL issues error
1301; SYSTEM means that SQL
issues warning 1302 saying that it
behaves like RESTRICT; ON means
that NO ACTION behaves like
RESTRICT, without warning or
errors.
SAVE_DROPPED_TABLE_DDL The default
value is ON.
DDL is saved only if
SAVE_DROPPED-TABLE_DDL is
set to the default ON setting. HP
recommends that you do not
change this default value in
production environments. In
development and testing
environments, or for specific
applications where tables are
frequently created and dropped, it is
recommended that the value be set
to OFF. Under these conditions,
DDL files accumulate quickly and
there is no automated cleanup
mechanism. For more information,
see Removing Unneeded DDL Files
on page 12-8.
Table 6-4. Alternative Settings for Selected System Defaults (page4of6)
System Default Default Value Alternative Setting