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-15
Steps for Converting SQL/MP Applications to
SQL/MX Applications
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.
NonStop SQL/MX also has a report writer that performs similar functions in MXCI. To
migrate from the SQL/MP Report Writer to the SQL/MX Report Writer, see the
SQL/MX
Report Writer Guide.
Steps for Converting SQL/MP Applications to
SQL/MX Applications
Converting an SQL/MP application to an SQL/MX application involves:
1. Modifying the Source Code
on page 10-16:
2. Compiling the Application
on page 10-54
3. Optimizing Query Execution Performance
on page 10-59
4. Moving the Application From Development to Production
on page 10-60
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 DDL Statements and Utilities
on page 11-14.
VOLUME No
!Yes
Table 10-1. SQLCI Commands and MXCI Commands (page 7 of 7)
SQLCI Commands
Implemented
in MXCI? Comments