SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-48
Data Types
These settings affect the way NonStop SQL/MX processes NOT NULL and PRIMARY
KEY constraints, as follows:
•
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
FLOATTYPE Set to IEEE or TANDEM.
The default is TANDEM.