SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Reviewing and Setting System Defaults

HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001

6-8

Settings Required to Achieve ANSI Compliance

Table 6-2 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-2. 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