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-16
SQL/MX Utilities

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 5-6
on page 5-16.
Table 5-6. Comparing SQL/MP Utilities With SQL/MX Utilities (page 1 of 3)
SQL/MP Utility
Execution
Environment
SQL/MX
Equivalent
Execution
Environment
For more
information...
BACKUP Guardian BRCOM BACKUP Guardian Backup and
Restore 2
Manual and
SQL/MX
Installation
and
Management
Guide
CLEANUP SQLCI None N.A.
CONVERT SQLCI None N.A.
COPY SQLCI None N.A.
DataLoader/MP Guardian DataLoader/MX OSS DataLoader/
MX Reference
Manual
DCOM Guardian DCOM Guardian
DISPLAY USE OF SQLCI DISPLAY USE OF MXCI SQL/MX
Reference
Manual
DOWNGRADE
CATALOG
SQLCI None N.A.