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-16
SQL/MX Utilities
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
•
DROP SQL
•
DROP SQLMP ALIAS
•
DROP TRIGGER
•
INITIALIZE SQL
These new SQL/MX statements influence the privileges and availability of SQL/MX
database objects:
•
GRANT
•
GRANT EXECUTE
•
REGISTER CATALOG
•
REVOKE
•
REVOKE EXECUTE
•
UNREGISTER CATALOG
For more information about these statements, see the
SQL/MX Reference Manual.
SQL/MX Utilities
SQL/MX utilities are tools that help you manage the files and data in your SQL/MX
database. Some of the utilities that are supported in NonStop SQL/MP are also
supported in NonStop SQL/MX. See Table 11-6
on page 11-17.