SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting an SQL/MP Database to SQL/MX Tables
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
11-15
SQL/MX DDL Statements
ALTER TABLE Yes For more information, see the SQL/MX
Reference Manual.
ALTER VIEW No In NonStop SQL/MX, you cannot alter views. To
change a view, you must drop and then re-create
the view.
COMMENT No
CONTINUE No
CREATE CATALOG Yes For more information, see the SQL/MX
Reference Manual.
CREATE COLLATION No Collations are not supported in NonStop
SQL/MX.
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 11-5. SQL/MP and SQL/MX DDL Statements (page 2 of 2)
SQL/MP DDL
Statements
Implemented
in SQL/MX? Comments