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-10
Converting SQLCI Scripts to NonStop SQL/MX
CLEANUP No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
CONVERT No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
COPY No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
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 10-15.
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 DDL Statements and Utilities
on page 11-14.
Table 10-1. SQLCI Commands and MXCI Commands (page 2 of 7)
SQLCI Commands
Implemented
in MXCI? Comments