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-17
SQL/MX Utilities
DOWNGRADE
SYSTEM
CATALOG
SQLCI None N.A.
DSAP Guardian DSAP Guardian
DUP SQLCI DUP MXCI SQL/MX
Reference
Manual
EDIT SQLCI EDIT Guardian Edit User’s
Guide and
Reference
Manual
EXPLAIN SQLCI EXPLAIN Table-valued
stored
function
SQL/MX
Reference
Manual and
SQL/MX
Query Guide
FILEINFO SQLCI SHOWLABEL and
mxtool INFO
MXCI and
OSS,
respectively
SQL/MX
Reference
Manual
FILENAMES SQLCI None N.A.
FILES SQLCI None N.A.
FUP SQLCI FUP Guardian File Utility
Program
(FUP)
Reference
Manual
GOAWAY Guardian mxtool GOAWAY OSS SQL/MX
Reference
Manual
INVOKE SQLCI INVOKE and
SHOWDDL
MXCI SQL/MX
Reference
Manual
LOAD SQLCI None (The import
utility provides
similar functionality
in NonStop
SQL/MX.)
N.A. SQL/MX
Reference
Manual.
MODIFY
CATALOG
SQLCI None N.A.
MODIFY LABEL SQLCI None N.A.
Table 5-6. Comparing SQL/MP Utilities With SQL/MX Utilities (page 2 of 3)
SQL/MP Utility
Execution
Environment
SQL/MX
Equivalent
Execution
Environment
For more
information...