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

Standard SQL and SQL/MX
HP NonStop SQL/MX Reference Manual—540440-003
E-2
ISO Standards
ISO Standards
These ISO documents govern SQL:
•
ISO/IEC 9075-1:1999, Information technology—Database languages—SQL—Part
1: Framework (SQL/Framework)
•
ISO/IEC 9075-1:1999/Amd.1:2000
•
ISO/IEC 9075-2:1999, Information technology—Database languages—SQL—Part
2: Foundation (SQL/Foundation)
•
ISO/IEC 9075-5:1999, Information technology—Database languages—SQL—Part
5: Host Language Bindings (SQL/Bindings)
For more information about ISO standards, see:
•
ISO Web site: http://www.iso.ch/
•
ISO Store Web site: http://www.iso.org/iso/en/prods-services/ISOstore/store.html
SQL/MX Compliance
The ANSI and ISO SQL standards require conformance claims to state the type of
conformance and the implemented facilities. SQL/MX products provide full or partial
conformance. This table lists the Core SQL:1999 features for which NonStop SQL/MX
offers full conformance:
ID Feature
E011 Numeric data types
E021 Character data types
E031 Identifiers
E051 Basic query specification
E061 Basic predicates and search conditions
E081 Basic privileges
E091 Set functions
E101 Basic data manipulation
E111 Single row SELECT statement
E131 Null value support (nulls in lieu of values)
E151 Transaction support
E152 Basic SET TRANSACTION statement
E171 SQLSTATE support
F031 Basic schema manipulation
F041 Basic joined table
F131 Grouped operations