SQL/MX Report Writer Guide

Migration from SQL/MP Report Writer to SQL/MX
Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
A-2
Error Handling
•
RESET REPORT TOTAL (column-name) allows only one column.
•
Subqueries are not allowed within SQL/MX report writer commands.
•
For logical folding, SQL/MX report writer does not maintain spaces between
columns. The next folded column begins at the first print position of the next line,
regardless of the SPACE option setting.
•
Display of exponents of an integer data type results in approximate floating point
format:
•
Numeric expressions are evaluated to these data types:
Error Handling
•
SQL/MX report writer parses a command until it encounters an error. At that time,
an error message is issued, and parsing stops.
•
SET LEFT/RIGHT MARGIN ALL issues a syntax error.
•
If nonfatal errors are encountered in processing a report (a LIST command has
been issued), SQL/MX report writer displays the report first, followed by the errors
encountered. Currently, the only such error is error 15521.
Single and Double Quotes
•
You must enclose string literals in single quotes.
•
You must enclose AS clause modifiers in single quotes.
•
You must enclose a special character decoration or filler character (such as $, +,
or *) in a quoted string (such as an AS clause modifier) in single quotes, plus an
additional set of single quotes.
•
You must enclose option values in SET commands in single quotes.
•
In SQL/MX report writer, you must use double quotes to:
°
Indicate a case-sensitive column name
°
Indicate a column name that is the same as an SQL/MX keyword
SQL/MP Report Writer SQL/MX Report Writer
4.000000 4.000000000000000000E+000
When … Resulting data type is … Display length is …
All operands are
integers
SQLDT_64BIT_S 21
One or more operands
are FLOAT
SQLDT_IEEE_DOUBLE 23