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-12
Converting SQLCI Scripts to NonStop SQL/MX
INVOKE Yes The SQL/MX INVOKE command provides similar
information, including record descriptions that
correspond to a row in the specified table or
view. To obtain more information about a
SQL/MX object, for example, when you need to
re-create it, use the SQL/MX SHOWDDL
command. For more information, see the
SQL/MX Reference Manual.
Utility. See SQL/MX Utilities
on page 5-16.
LIST Yes
LOAD No NonStop SQL/MX has no equivalent command
for loading data from a SQL/MX table or a
Guardian file into another SQL/MX table or its
indexes. The SQL/MX import utility moves data
from an input file in ASCII or UCS2 format into an
existing SQL/MX table. For more information
about import, see the SQL/MX Reference
Manual and the SQL/MX Installation and
Management Guide.
Utility. See SQL/MX Utilities
on page 5-16.
LOG Yes
MODIFY CATALOG No Utility.See SQL/MX Utilities
on page 5-16.
MODIFY LABEL No Utility. See SQL/MX Utilities
on page 5-16.
MODIFY REGISTER No Utility. See SQL/MX Utilities
on page 5-16.
NAME Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
OBEY Yes
OUT No
OUT_REPORT No Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
PAGE FOOTING Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
PAGE TITLE Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
PERUSE No Utility. See SQL/MX Utilities
on page 5-16.
PREPARE Yes
Table 4-1. SQLCI Commands and MXCI Commands (page4of6)
SQLCI Commands
Implemented
in MXCI? Comments