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

Converting an SQL/MP Database to SQL/MX Tables
HP NonStop SQL/MX Database and Application Migration Guide—540435-005
11-19
SQL/MX Utilities
New SQL/MX Utilities
NonStop SQL/MX introduces several new utilities that do not exist in NonStop SQL/MP.
See Table 11-7
.
TEDIT SQLCI TEDIT Guardian PS TEXT
EDIT
Reference
Manual
UPGRADE
CATALOG
SQLCI None N.A.
UPGRADE
SYSTEM
CATALOG
SQLCI None N.A.
VERIFY SQLCI mxtool VERIFY OSS SQL/MX
Reference
Manual
Table 11-7. New SQL/MX Utilities (page 1 of 2)
SQL/MX Utility
Execution
Environment Function
import OSS or MXCI Imports data from an input file in ASCII or
UCS2 format into an SQL/MX table.
migrate OSS Copies metadata from SQL/MX Release 1.8
into SQL/MX Release 2.x system metadata
tables.
MODIFY MXCI Performs partition operations on range and
hash partitions of SQL/MX tables and
indexes. The SQL/MX MODIFY utility does
not have the DDL extensions as the SQL/MP
MODIFY utility does.
mxexportddl OSS Captures SQL/MX metadata and saves it in
XML format for diagnosing problems.
MXGNAMES Guardian Converts one or more ANSI table names into
a list of corresponding Guardian file names,
appropriately formatted for TMF or Backup
and Restore 2.
Table 11-6. Comparing SQL/MP Utilities With SQL/MX Utilities (page 3 of 3)
SQL/MP Utility
Execution
Environment
SQL/MX
Equivalent
Execution
Environment
For more
information...