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-13
Converting SQLCI Scripts to NonStop SQL/MX
PAGE TITLE Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 10-15.
PERUSE No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
PREPARE Yes
PURGE No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
PURGEDATA Yes Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
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 10-15.
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 10-15.
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 10-15.
SAVE No
SECURE No Utility. See SQL/MX DDL Statements and Utilities
on page 11-14.
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 10-15.
SET PARAM Yes
SET SESSION No
Table 10-1. SQLCI Commands and MXCI Commands (page 5 of 7)
SQLCI Commands
Implemented
in MXCI? Comments