SQL/MX Report Writer Guide

Using MXCI and the Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
2-6
Listing Rows of a Report
You can use the RESET, RESET LAYOUT, and RESET STYLE commands to reset
specific options or all options to their default values. For example, to reset the line
spacing to 1 (single spacing) and reset all style options to their default values, enter:
>> RESET LAYOUT LINE_SPACING;
>> RESET STYLE * ;
You can enter SET, RESET, and SHOW commands at the standard MXCI prompt (>>)
or the select-in-progress prompt (S>).
Scenarios throughout this guide illustrate how options affect your reports. For a
summary of options, see Report Writer Components on page 1-12.
Listing Rows of a Report
To retrieve rows of data, use the SELECT command.
As shown in Figure 2-2, Listing Rows, on page 2-7, you can use the LIST command to
display rows following the last displayed row or to return to the first retrieved row
before displaying more rows.
LIST Command Options
The three options for the LIST command are:
*
n is the current setting for LIST_COUNT.
Option Action
FIRST n
*
Lists the first n rows retrieved
NEXT n
*
Lists the next n rows from the last displayed row
ALL Lists all selected rows and then returns you to the
standard prompt and cancels the SELECT command
Note. The number you specify for the value of n specifies rows of retrieved data. Therefore, if
the information from a row appears on two output lines and you specify LIST NEXT 3, six
output lines are listed in addition to any headings, titles, footings, and other output that is not
counted.