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

Standard SQL and SQL/MX
HP NonStop SQL/MX Reference Manual—540440-003
E-5
SQL/MX Compliance
NonStop SQL/MX does not support these subfeatures:
F051-07 LOCALTIME (equivalent to CAST (CURRENT_TIME
AS TIME WITHOUT TIME ZONE))
F051-08 LOCALTIMESTAMP (equivalent to
CAST(CURRENT_TIMESTAMP AS TIMESTAMP WITHOUT
TIME ZONE))
F081 UNION and
EXCEPT in views
NonStop SQL/MX supports UNION but not EXCEPT in views
F221 Explicit defaults NonStop SQL/MX supports use of DEFAULT in INSERT, but not
in UPDATE
F261 CASE
expressions
NonStop SQL/MX supports these subfeatures:
F261-01 Simple CASE
F261-02 Searched CASE
NonStop SQL/MX does not support these subfeatures:
F261-03 NULLIF
F261-04 COALESCE
F311 Schema definition
statement
NonStop SQL/MX partially supports these subfeatures:
F311-01 CREATE SCHEMA (NonStop SQL/MX does not
support creation of a schema and its contents in a single
statement. Objects must be created in a particular order,
dependent objects first.)
F311-02 CREATE TABLE for persistent base tables
(NonStop SQL/MX does not support creation of a schema and
its contents in a single statement. Objects must be created in
a particular order, dependent objects first.)
F311-03 CREATE VIEW (without WITH CHECK OPTION and
without Feature F081 “UNION and EXCEPT in views”
SQL/MX views cannot refer to tables created in the same
CREATE SCHEMA)
F311-04 CREATE VIEW: WITH CHECK OPTION (Without
support for Feature F081 “UNION and EXCEPT in views”
SQL/MX views cannot refer to tables created in the same
CREATE SCHEMA)
F311-05 GRANT statement (NonStop SQL/MX does not
support creation of a schema and its contents in a single
statement, including performing grant operations. Objects
must be created in a particular order, dependent objects first.)
T321 Basic
SQL-invoked routines
NonStop SQL/MX fully supports this subfeature:
T321-04 CALL statement
ID, Feature Level of Support