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

HP NonStop SQL/MX Reference Manual—540440-003
E-1
E Standard SQL and SQL/MX
This appendix describes NonStop SQL/MX conformance to the SQL standards
established by the American National Standards Institute (ANSI) and the International
Organization for Standardization (ISO). It describes:
•
ANSI SQL Standards on page E-1
•
ISO Standards on page E-2
•
SQL/MX Compliance on page E-2
•
SQL/MX Extensions to Standard SQL on page E-6
•
Character Set Support on page E-7
This appendix documents NonStop SQL/MX conformance with the standards criteria
for SQL:1999, which replaced ANSI SQL-92. The mandatory portion of SQL:1999 is
referred to as Core SQL:1999 and is found in SQL:1999 Part 2 (Foundation) and Part 5
(Bindings). Core SQL:1999 contains all Entry SQL-92, much of Intermediate SQL-92,
and some of Full SQL-92, including some new SQL:1999 features.
Annex F of Part 2 in the table “SQL/Foundation feature taxonomy and definition for
Core SQL” describes Foundation features. Annex F of Part 5 in the table
“SQL/Bindings feature taxonomy and definition for Core SQL” describes Bindings
features.
ANSI SQL Standards
These ANSI documents govern SQL:
•
ANSI/ISO/IEC 9075-1:1999, Information technology—Database languages—
SQL—Part 1: Framework (SQL/Framework)
•
ANSI/ISO/IEC 9075-1:1999/Amd.1:2000
•
ANSI/ISO/IEC 9075-2:1999, Information technology—Database languages—
SQL—Part 2: Foundation (SQL/Foundation)
•
ANSI/ISO/IEC 9075-5:1999, Information technology—Database languages—
SQL—Part 5: Host Language Bindings (SQL/Bindings)
To obtain copies of the ANSI standards, refer to the ANSI eStandards Store at:
http://webstore.ansi.org/ansidocstore/default.asp
The X3 or INCITS standards offer a subset of the ANSI standards that include the SQL
standard. To obtain copies, see the International Committee for Information Technology
Standards at:
http://www.cssinfo.com/ncitsgate.html