SQL/MX Comparison Guide for SQL/MP Users

HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
7-1
7 Utility Differences
SQL/MX 2.0 includes utilities that perform tasks such as populating indexes, displaying
information about files or DDL, managing partitions, and so on. These SQL/MX utilities
are similar to those in NonStop SQL/MP, but not identical:
DISPLAY USE OF Command
In NonStop SQL/MX, DISPLAY USE OF is an MXCI command that provides usage
information only for statically compiled modules, such as:
•
Modules using a specific SQL object such as a table, index, or MP alias
•
All the SQL objects used by a module or set of modules
NonStop SQL/MP’s implementation of this command provides information on various
objects:
•
All objects using a specific SQL 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 on each object displayed.
For syntax and description of this command, see “MXCI Commands” in the SQL/MX
Reference Manual.
IMPORT Command
You can use SQL/MX’s IMPORT command to import data from a file (ASCII or binary)
into a NonStop SQL/MX table. IMPORT executes at the OSS or MXCI command
prompt. It is similar to but not equivalent to SQL/MP’s LOAD command. See “SQL/MX
Utilities” in the SQL/MX Reference Manual for details.
MXTOOL Utility
Earlier releases of NonStop SQL/MX supported only a limited set of tools with the
MXTOOL utility. NonStop SQL/MX Release 2 provides a tool, the MXTOOL utility, that
gives you additional options. The MXTOOl utility allows you verify the contents of an
SQL/MX object, fix parts of the metadata and label information, return information
about SQL/MX objects, and remove both damaged and undamaged objects from
metadata or labels in a uniform way.
The MXTOOL utility performs these operations:
FIXUP Similar to various SQL/MP operations