SQL/MX Comparison Guide for SQL/MP Users

Quick Reference to Differences
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
2-5
CREATE CONSTRAINT
statement
Changed Performed with CREATE TABLE
statement. See SQL/MX Reference
Manual
CREATE INDEX statement Yes Some differences. See SQL/MX
Reference Manual
CREATE SYSTEM
CATALOG statement
Changed See Organization of Catalogs and
Schemas on page 6-2 and SQL/MX
Reference Manual
CREATE TABLE statement Yes Some differences. See SQL/MX
Reference Manual
CREATE VIEW statement Changed Some differences. See Views on
page 6-6 and SQL/MX Reference
Manual
CURRENT function Yes See SQL/MX Reference Manual
CURRENT_TIMESTAMP
function
Yes See SQL/MX Reference Manual
Cursors Yes See SQL/MX Programming Guide
for C and COBOL and SQL/MX
Reference Manual
c89 Yes See SQL/MX Programming Guide
for C and COBOL
Data Dictionary Yes Metadata in NonStop SQL/MX. See
SQL/MX Reference Manual
Data types Yes See SQL/MX Reference Manual
DATE data type Yes See SQL/MX Reference Manual
DATE_FORMAT option Yes See SQL/MX Report Writer Guide
Date-time data types Changed See Section 3, DML Features
Date-time functions Changed See Section 3, DML Features
Date-time literals Changed See Section 3, DML Features
DATEFORMAT function Yes See SQL/MX Reference Manual
DATETIME data type Changed See Section 3, DML Features and
SQL/MX Reference Manual
DAYOFWEEK function Yes See SQL/MX Reference Manual
Table 2-1. NonStop SQL/MP Contents Compared to NonStop
SQL/MX (page 5 of 18)
NonStop SQL/MP Item
Implemented
in NonStop
SQL/MX? Comments