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-14
SQL/MX DDL Statements and Utilities
SQL/MX DDL Statements and Utilities
The next subsections list the SQL/MX DDL statements and utilities that are available in
NonStop SQL/MX for creating and maintaining a SQL/MX database:

SQL/MX DDL Statements on page 5-14

SQL/MX Utilities on page 5-16
SQL/MX DDL Statements
Many of the DDL statements that are supported in NonStop SQL/MP are also
supported in NonStop SQL/MX. See Table 5-5
. SQL/MX DDL statements, which you
run from MXCI, create, alter, or drop SQL/MX database objects.
Note. You cannot create, alter, or drop SQL/MP database objects with SQL/MX DDL
statements. To create, alter, or drop SQL/MP database objects, you must use SQL/MP DDL
statements in SQLCI.
Table 5-5. SQL/MP and SQL/MX DDL Statements (page1of2)
SQL/MP DDL
Statements
Implemented
in SQL/MX? Comments
ALTER CATALOG No In NonStop SQL/MX, you cannot alter catalogs.
However, you can use the REGISTER CATALOG
and UNREGISTER CATALOG statements in
NonStop SQL/MX.
ALTER COLLATION No Collations are not supported in NonStop
SQL/MX.
ALTER INDEX Yes For more information, see the SQL/MX
Reference Manual.
ALTER PROGRAM No
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.