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-14
Converting SQLCI Scripts to NonStop SQL/MX
Migrating From SQL/MP Report Writer to SQL/MX Report
Writer
The SQL/MP Report Writer enables you to format data retrieved with a SELECT
statement entered in SQLCI and to display or print the formatted data in a report. The
report writer includes a set of formatting commands and options that control the layout
and style of reports.
SHOW LAYOUT Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
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 4-14.
SHOW SESSION Yes
SHOW STYLE Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
SUBTOTAL Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
SYSTEM No
TEDIT No Utility.See SQL/MX Utilities
on page 5-16.
TOTAL Yes Report Writer command. See Migrating From
SQL/MP Report Writer to SQL/MX Report Writer
on page 4-14.
UPGRADE CATALOG No Utility. See SQL/MX Utilities
on page 5-16.
UPGRADE SYSTEM
CATALOG
No Utility. See SQL/MX Utilities
on page 5-16.
VERIFY Changed SQL/MX VERIFY is an OSS command-line utility
run from mxtool that reports whether SQL/MX
objects and programs are consistently described
in file labels, resource forks, and metadata. For
more information, see the SQL/MX Reference
Manual.
Utility. See SQL/MX Utilities
on page 5-16.
VOLUME No
!Yes
Table 4-1. SQLCI Commands and MXCI Commands (page6of6)
SQLCI Commands
Implemented
in MXCI? Comments