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-14
Collations
view to update the view. In NonStop SQL/MX, you need only have appropriate security
on the view itself, not on the underlying table, to update the view.
For more information about SQL/MX views, see the
SQL/MX Reference Manual.
Collations
Unlike NonStop SQL/MP, NonStop SQL/MX does not support collations other than the
DEFAULT collation, which uses binary ordering. In NonStop SQL/MX, you cannot
create collations, so the CREATE COLLATION statement does not exist in NonStop
SQL/MX. When you create an SQL/MX table, you can specify only DEFAULT in the
COLLATE clause of a character string column. For more information, see the
SQL/MX
Reference Manual.
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 an SQL/MX database:
•
SQL/MX DDL Statements on page 11-14
•
SQL/MX Utilities on page 11-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 11-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 11-5. SQL/MP and SQL/MX DDL Statements (page 1 of 2)
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