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-14
Converting SQLCI Scripts to NonStop SQL/MX
SET STYLE Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
SHOW CONTROL Changed In MXCI, SHOWCONTROL is one word instead
of two. Otherwise, the command is the same in
NonStop SQL/MP and NonStop SQL/MX.
SHOW DEFINE Yes
SHOW DEFMODE No
SHOW LAYOUT Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
SHOW PARAM Yes
SHOW PREPARED No
SHOW REPORT Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
SHOW SESSION Yes
SHOW STYLE Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
SUBTOTAL Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
SYSTEM No
TEDIT No Utility.See SQL/MX DDL Statements and Utilities
on page 11-14.
TOTAL Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
UPGRADE CATALOG No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
UPGRADE SYSTEM
CATALOG
No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
Table 10-1. SQLCI Commands and MXCI Commands (page 6 of 7)
SQLCI Commands
Implemented
in MXCI? Comments