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

Standard SQL and SQL/MX
HP NonStop SQL/MX Reference Manual—540440-003
E-3
SQL/MX Compliance
This table lists the Core SQL:1999 features for which NonStop SQL/MX offers partial
support:
F181 Multiple module support
F201 CAST function
F471 Scalar subquery values
F481 Expanded NULL predicate
B012 Embedded C
B013 Embedded COBOL
ID, Feature Level of Support
E071 Basic query
expressions
NonStop SQL/MX fully supports this subfeature:
E071-02 UNION ALL table operator
NonStop SQL/MX partially supports these subfeatures:
E071-01 UNION [DISTINCT] table operator (NonStop
SQL/MX does not support explicitly specifying DISTINCT)
E071-05 Columns combined by table operators need not
have exactly the same type (NonStop SQL/MX has rules for
determining result types that are not identical to SQL '99
rules)
E071-06 table operators in subqueries (NonStop SQL/MX
allows only UNION in subqueries)
NonStop SQL/MX does not support this subfeature:
E071-03 EXCEPT [DISTINCT] table operator
E121 Basic cursor
support
NonStop SQL/MX fully supports these subfeatures:
E121-01 DECLARE CURSOR
E121-02 ORDER BY columns need not be in select list
E121-06 Positioned UPDATE statement
E121-07 Positioned DELETE statement
E121-08 CLOSE statement
NonStop SQL/MX partially supports these subfeatures:
E121-04 OPEN statement (SQL/MX syntax does not match
that of SQL '99)
E121-10 FETCH statement, implicit NEXT (SQL/MX syntax
does not match that of SQL '99)
E121-17 WITH HOLD cursors (supported only for SELECT
statements that use stream access mode or an embedded
UPDATE or embedded DELETE)
ID Feature