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-13
Converting SQLCI Scripts to NonStop SQL/MX
PURGE No Utility. See SQL/MX Utilities on page 5-16.
PURGEDATA Yes Utility. See SQL/MX Utilities
on page 5-16.
REPORT FOOTING Yes Report Writer
REPORT TITLE Yes Report Writer
RESET DEFINE No
RESET LAYOUT Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
RESET PARAM Yes
RESET PREPARED No
RESET REPORT Changed Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
RESET REPORT SELECT is not supported in
NonStop SQL/MX.
RESET SESSION No
RESET STYLE Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
SAVE No
SECURE No Utility. See SQL/MX Utilities
on page 5-16.
SET DEFINE Yes
SET DEFMODE No
SET LAYOUT Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
SET PARAM Yes
SET SESSION No
SET STYLE Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
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
Table 4-1. SQLCI Commands and MXCI Commands (page5of6)
SQLCI Commands
Implemented
in MXCI? Comments