SQL/MP to SQL/MX Database and Application Migration Guide

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MP to NonStop SQL/MX Database and Application Migration Guide—666211-001
4-11
Converting SQLCI Scripts to NonStop SQL/MX
DROP SYSTEM
CATALOG
No NonStop SQL/MX uses the DROP SQL
command to put NonStop SQL/MX in an
uninitialized state and drop a system catalog that
has no user-created catalogs. For more
information, see the SQL/MX Reference Manual.
DUP Yes Utility. See SQL/MX Utilities
on page 5-16.
EDIT No Utility. See SQL/MX Utilities
on page 5-16.
ENV Yes
ERROR Yes
EXECUTE Yes
EXIT Yes
EXPLAIN Changed EXPLAIN is a SQLCI directive in NonStop
SQL/MP and a table-valued stored function in
NonStop SQL/MX. See SQL/MX DDL Statements
on page 5-14.
FC Yes
FILEINFO No NonStop SQL/MX uses the MXCI command
SHOWLABEL to display file-label information for
SQL/MX objects. This information includes the
object version, physical location, and other
characteristics. Supported objects include tables,
trigger temporary tables, views, and indexes.
For more information, see the SQL/MX
Reference Manual.
Utility. See SQL/MX Utilities
on page 5-16.
FILENAMES No Utility. See SQL/MX Utilities
on page 5-16.
FILES No Utility. See SQL/MX Utilities
on page 5-16.
FUP No Utility. See SQL/MX Utilities
on page 5-16.
HELP No
HISTORY Yes
INFO DEFINE Yes
INITIALIZE SQL Yes
Table 4-1. SQLCI Commands and MXCI Commands (page3of6)
SQLCI Commands
Implemented
in MXCI? Comments