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-13
Settings Required to Achieve ANSI Compliance
Settings Required to Achieve ANSI Compliance
Table 6-5 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-5. 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