SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Settings Required to Achieve ANSI Compliance
Table 7 (page 72) 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 7 System Default Settings to Achieve ANSI Compliance
ANSI-Compliant ValueDefault ValueSystem Default
SERIALIZABLEREAD COMMITTEDISOLATION_LEVEL
ANSIANSINAMETYPE
ONOFFNOT_NULL_CONSTRAINT_ DROPPABLE_OPTION
ONOFFPRIMARY_KEY_CONSTRAINT_ DROPPABLE_OPTION
FALSETRUEREADONLY_CURSOR
OFFOFFRECOMPILATION_WARNINGS
ONONREF_CONSTRAINT_NO_ ACTION_LIKE_RESTRICT
72 Reviewing and Setting System Defaults