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-12
Converting SQLCI Scripts to NonStop SQL/MX
INITIALIZE SQL Yes
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 an
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 DDL Statements and Utilities
on page 11-14.
LIST Yes
LOAD No NonStop SQL/MX has no equivalent command
for loading data from an 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 DDL Statements and Utilities
on page 11-14.
LOG Yes
MODIFY CATALOG No Utility.See SQL/MX DDL Statements and Utilities
on page 11-14.
MODIFY LABEL No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
MODIFY REGISTER No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
NAME Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
OBEY Yes
OUT No
OUT_REPORT No Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
PAGE FOOTING Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
Table 10-1. SQLCI Commands and MXCI Commands (page 4 of 7)
SQLCI Commands
Implemented
in MXCI? Comments