SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Tables to SQL/MX Tables
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
5-15
SQL/MX DDL Statements
New SQL/MX DDL Statements
NonStop SQL/MX introduces new DDL statements to create database objects, such as
schemas, SQL/MP aliases, stored procedures, and triggers, that do not exist in
NonStop SQL/MP:

ALTER SQLMP ALIAS

ALTER TRIGGER

CREATE PROCEDURE

CREATE SCHEMA

CREATE SQLMP ALIAS

CREATE TRIGGER

DROP PROCEDURE

DROP SCHEMA
CREATE
CONSTRAINT
No In NonStop SQL/MX, you cannot create a
constraint separately from the table. A constraint
is created at the same time that you create the
table.
CREATE INDEX Yes For more information, see the SQL/MX
Reference Manual.
CREATE TABLE Yes For more information, see the SQL/MX
Reference Manual.
CREATE VIEW Changed In NonStop SQL/MX, you can only create an
ANSI view; you cannot create shorthand or
protection views. For more information, see the
SQL/MX Reference Manual.
DROP Changed NonStop SQL/MX has implemented DROP as
separate SQL statements:

DROP CATALOG

DROP INDEX

DROP PROCEDURE

DROP SCHEMA

DROP SQL

DROP SQLMP ALIAS

DROP TABLE

DROP TRIGGER

DROP VIEW
For more information, see the SQL/MX
Reference Manual.
HELP TEXT No
UPDATE STATISTICS Yes For more information, see the SQL/MX
Reference Manual.
Table 5-5. SQL/MP and SQL/MX DDL Statements (page2of2)
SQL/MP DDL
Statements
Implemented
in SQL/MX? Comments