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-10
Converting SQLCI Scripts to NonStop SQL/MX
CLEANUP No Utility. See SQL/MX Utilities on page 5-16.
CONVERT No Utility. See SQL/MX Utilities
on page 5-16.
COPY No Utility. See SQL/MX Utilities
on page 5-16.
CREATE SYSTEM
CATALOG
No To create the system catalog in NonStop
SQL/MX, run the InstallSqlmx script. For
more information, see the SQL/MX Installation
and Management Guide.
DELETE DEFINE Yes
DETAIL Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
DISPLAY STATISTICS Changed The SQL/MX version of DISPLAY STATISTICS
uses slightly different statistics information from
the SQL/MP version. For more information, see
the SQL/MX Reference Manual.
DISPLAY USE OF Changed NonStop SQL/MX uses the MXCI command
DISPLAY USE OF to provide usage information
only for statically compiled modules, including:

Modules using a specific SQL/MX object
such as a table, index, or SQL/MP alias

All the SQL/MX objects used by a module or
set of modules
For NonStop SQL/MP, DISPLAY USE OF
provides information about various objects,
including:

All objects using a specific SQL/MP object,
such as a table, index, view, or collation.
NonStop SQL/MP displays all tables, views,
indexes, collations, and programs
associated with that object.

Optionally, detailed information about each
object is displayed.
For more information, see the SQL/MX
Reference Manual and the SQL/MP Reference
Manual.
DOWNGRADE
CATALOG
No Utility. See SQL/MX Utilities
on page 5-16.
DOWNGRADE
SYSTEM CATALOG
No Utility. See SQL/MX Utilities
on page 5-16.
Table 4-1. SQLCI Commands and MXCI Commands (page2of6)
SQLCI Commands
Implemented
in MXCI? Comments