SQL/MX 2.x Reference Manual (H06.04+)
Introduction
HP NonStop SQL/MX Reference Manual—540440-003
1-32
ANSI Compliance and SQL/MX Extensions
ANSI Compliance and SQL/MX Extensions
NonStop SQL/MX complies most closely with Entry Level SQL as described in ANSI
X3.135-1992 and ISO/IEC 9075:1992. NonStop SQL/MX also includes some features
from Intermediate and Full Level ANSI/ISO SQL in addition to special SQL/MX
extensions to the SQL language.
Statements and SQL elements in this manual are ANSI compliant unless specified as
SQL/MX extensions. For details about NonStop SQL/MX's conformance with
SQL:1999 standards, see Appendix E, Standard SQL and SQL/MX.
Default Settings for ANSI Compliance
To establish an ANSI-compliant database, set these default attributes as follows:
To set these default attributes, use the CONTROL QUERY DEFAULT Statement on
page 2-33. For more information on these default attributes, see System Defaults Table
on page 10-30.
ANSI-Compliant Statements
These statements are ANSI compliant, but some might contain SQL/MX extensions:
•
ALLOCATE CURSOR statement
•
ALLOCATE DESCRIPTOR statement
•
ALTER TABLE
•
BEGIN DECLARE SECTION declaration
•
CALL statement
•
CLOSE statement
•
COMMIT WORK statement
•
CREATE PROCEDURE statement
•
CREATE SCHEMA statement
•
CREATE TABLE statement
•
CREATE TRIGGER statement
•
CREATE VIEW statement
•
DEALLOCATE DESCRIPTOR statement
•
DEALLOCATE PREPARE statement
•
DECLARE CURSOR declaration
•
DELETE statement
•
DESCRIBE statement
ISOLATION_LEVEL 'serializable'
NAMETYPE 'ansi'
NOT_NULL_CONSTRAINT_DROPPABLE_OPTION 'on'
PRIMARY_KEY_CONSTRAINT_DROPPABLE_OPTION 'on'
READONLY_CURSOR 'false'
REF_CONSTRAINT_NO_ACTION_LIKE_RESTRICT 'on'