SQL/MX 2.x Reference Manual (H06.04+)

Standard SQL and SQL/MX
HP NonStop SQL/MX Reference Manual—540440-003
E-4
SQL/MX Compliance
NonStop SQL/MX does not support this subfeature:
E121-03 Value expressions in ORDER BY clause
E141 Basic integrity
constraints
NonStop SQL/MX fully supports these subfeatures:
E141-01 NOT NULL constraints
E141-02 UNIQUE constraint of NOT NULL columns
E141-03 PRIMARY KEY constraints
E141-06 CHECK constraints
NonStop SQL/MX partially supports these subfeatures:
E141-04 Basic FOREIGN KEY constraint with the NO
ACTION default for referential delete and update action(s)
(NonStop SQL/MX has the limitation that the “referenced-table
cannot be the same as table”)
E141-07 Column defaults (NonStop SQL/MX specifies a
subset of datetime value functions that Core '99
allows to be specified. NonStop SQL/MX does not enforce the
conformance rule that “Without Feature F411 “Time zone
specification”, CURRENT_TIME and
CURRENT_TIMESTAMP shall not be specified.”)
NonStop SQL/MX does not support these subfeatures:
E141-08 NOT NULL inferred on PRIMARY KEY (NOT NULL
is not required to be inferred on UNIQUE constraints)
E141-10 Names in a foreign key can be specified in any order
(The column in the column list associated with
REFERENCES must be in the same order as the column in
the column list associated with FOREIGN KEY)
E161 SQL comments
using leading double
minus
MXCI does not properly process SQL comments when they are
issued from the NonStop Manager
F051 Basic date and
time
NonStop SQL/MX fully supports these subfeatures:
F051-01 DATE data type (and literal)
F051-02 TIME data type (and literal) with fractional seconds
precision of at least 0
F051-03 TIMESTAMP data type (and literal) with fractional
seconds precision of at least 0 and 6
F051-04 Comparison predicate for DATE, TIME, and TIME-
STAMP data types
F051-05 Explicit CAST between datetime types and character
types
F051-06 CURRENT_DATE
ID, Feature Level of Support