SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-39
Constraint Droppable Options
Constraint Droppable Options
These table entries describe settings that enable NonStop SQL/MX to ensure that the
defaults for certain constraints are set to NOT DROPPABLE:
These settings affect the way NonStop SQL/MX processes NOT NULL and PRIMARY
KEY constraints:
•
If a column is defined with the NOT NULL NOT DROPPABLE constraint, the
executor does not check for null—thereby improving performance of updates and
inserts. The NOT NULL NOT DROPPABLE constraint also eliminates the need for
a null indicator, which reduces space requirements.
•
If a column or a column list within a table is defined with the PRIMARY KEY NOT
DROPPABLE constraint, the primary key column or column list can be used as a
storage key—the most efficient method for partitioning by values of a unique key.
In this case, a separate index is not required for the primary key.
Data Types
This attribute controls whether the output of dynamic SELECT statements and dynamic
parameters that are FLOAT data types should be treated as Tandem FLOAT format or
IEEE FLOAT format:
Attribute Setting
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
Set to ON (DROPPABLE) or OFF (NOT DROPPABLE).
This option is used if DROPPABLE or NOT
DROPPABLE does not appear in the definition of a NOT
NULL column constraint.
The default is OFF.
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
Set to ON (DROPPABLE) or OFF (NOT DROPPABLE).
This option is used if DROPPABLE or NOT
DROPPABLE does not appear in the definition of a
PRIMARY KEY constraint.
The default is OFF.
Attribute Setting
FLOATTYPE Set to IEEE or TANDEM.
The default is TANDEM.