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

Reviewing and Setting System Defaults
HP NonStop SQL/MX Installation and Management Guide—523723-004
6-12
Settings to Achieve ANSI Compliance
Settings to Achieve ANSI Compliance
Table 6-4 lists the system default settings required to achieve ANSI compliance. If
these settings are used, all except these will have a significant negative impact on the
performance of your database:
•
NAMETYPE
•
RECOMPILATION_WARNINGS
•
REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT
Table 6-4. System Default Settings to Achieve ANSI Compliance
System Default Default Value ANSI-Compliant Value
ISOLATION_LEVEL READ COMMITTED SERIALIZABLE
NAMETYPE ANSI ANSI
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
OFF ON
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
OFF ON
READONLY_CURSOR TRUE FALSE
RECOMPILATION_WARNINGS OFF OFF
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT
ON ON