SQL/MX 2.x Database and Application Migration Guide (G06.23+, H06.04+, J06.03+)

Converting SQL/MP Applications to SQL/MX
Applications
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
10-11
Converting SQLCI Scripts to NonStop SQL/MX
DOWNGRADE
SYSTEM CATALOG
No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
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 DDL Statements and Utilities
on page 11-14.
EDIT No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
ENV Yes
ERROR Yes
EXECUTE Yes
EXIT Yes
EXPLAIN Changed EXPLAIN is an SQLCI directive in NonStop
SQL/MP and a table-valued stored function in
NonStop SQL/MX. See SQL/MX DDL Statements
and Utilities on page 11-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 DDL Statements and Utilities
on page 11-14.
FILENAMES No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
FILES No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
FUP No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
HELP No
HISTORY Yes
INFO DEFINE Yes
Table 10-1. SQLCI Commands and MXCI Commands (page 3 of 7)
SQLCI Commands
Implemented
in MXCI? Comments