SQL/MX Report Writer Guide

HP NonStop SQL/MX Report Writer Guide—527194-002
A-1
A
Migration from SQL/MP Report
Writer to SQL/MX Report Writer
This appendix discusses unsupported and changed commands and options, error
handling, and the use of single and double quotation marks in SQL/MX report writer.
Unsupported Commands, Options, and
Functions
•
ADD DEFINE
•
OUT_REPORT
•
RESET REPORT SELECT
•
RESET SESSION
•
SET SESSION
•
WRAP
•
CN[.m] display descriptor for multiline text
•
[LCT/GMT] display descriptor for DATE/TIME
•
More than one parameter in the same BETWEEN clause
•
Conditional expressions in parentheses (You must use nested IF/THEN/ELSE
clauses)
•
Ampersand (&) to break up a long string literal
•
Printing reports (You must print reports as LOG files from OSS, using the lp
command. For more information, see the Open System Services User’s Guide.)
Changed Commands and Options
•
An AS clause specified on CHAR/VARCHAR datatype in a DETAIL command
causes filler characters to be substituted for trailing spaces in the column value.
•
LIST, FIRST, NEXT, and ALL cannot be abbreviated. Enter the word.
•
LIST NEXT n must be explicitly typed. Pressing ENTER at the S> prompt does not
perform this command.
•
Setting LIST_COUNT does not implicitly enable report writer. You must explicitly
set MODE REPORT.
•
RESET REPORT commands allow only one option.