SQL/MX Report Writer Guide

Introduction to the NonStop SQL/MX Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
1-3
SQL Database Reports
SQL Database Reports
MXCI generates a default report definition for each SELECT command you enter
during your Report Writer session. You can override the default report by using layout
options, style options, and report formatting commands.
Layout and style options are global and not related to a specific SELECT command.
Your current layout and style options affect the output of any SELECT command you
enter during your report writer session.
Layout Options
Layout options control general properties of reports, such as page length, margin
settings, and the appearance of the entire report on the screen or printed page.
Style Options
Style options, such as the decimal character, underline character, or format of dates,
control the appearance of individual items in a report.
Report Formatting Commands
Report formatting commands specify a report template, including such elements as
detail lines, titles, and footings. These commands are related to a specific SELECT
command through database column references.
Report Design
To display or print data retrieved by the SELECT command, use the default report
definition or create a report definition of your own.
To use the default report format, accept the default style options, layout options, and
report formatting commands. See Default Report Format on page 1-6 for a report
created with the default report definition.
To design your own report, change the current report definition by entering report
formatting commands or by using the SET LAYOUT or SET STYLE commands to
change the default values.
Use the report writer features, the SELECT command, and the LIST command to
develop a report in stages and view each change as you make it.
When you are satisfied with the format and content of your report, you can enter the
LIST ALL command to produce the report. To print the report, you must log your
session and print the file from HP NonStop Kernel Open System Services (OSS).
Note. The current report definition determines the format of your report. A layout or style
option stays in effect until you set it to some other value, reset it to its default value, or exit
report writer mode.