NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
D-46
DETAIL Command
You can refer to a detail alias in other report formatting commands such as TOTAL
and SUBTOTAL, but you cannot refer to a detail alias in the DETAIL command
itself.
NEED [ number ]
advances to the next page before printing the next print item unless at least number
(an integer in the range 1 through 32,767) more lines fit on the page. The default is
1. (When you compute the number of lines you need, include lines for the page
footing.)
PAGE [number]
advances to the next page before printing the next print item, printing a page footing
and page title, if defined.
If you specify number (an integer in the range 1 through 32,767), report writer uses
number as the page number for the next page.
SKIP [ number ]
advances number (an integer in the range 1 through 32,767) lines before printing
the next print item. For example, SKIP 1 causes the print item to be printed on the
next line; SKIP 2 prints the item following one blank line. If fewer than number
lines remain on the page, the report writer advances to the top of the next page.
A line is defined in terms of the spacing specified by the current LINE_SPACING
option (see LINE_SPACING Option
on page L-14). To determine the position of the
next line, the report writer multiplies the value of LINE_SPACING by the value of
SKIP.
Omitting number is equivalent to specifying SKIP 1.
SPACE [ number ]
prints number (an integer in the range 0 through 255) spaces between the specified
print items. A space occupies one print position on the output line (one byte,
regardless of the character set in use).
If you omit the entire clause, the default is the value of the SPACE option of the
SET LAYOUT command. If you specify SPACE but omit number, the default is 1.
TAB [number]
prints the next print item at print position number of the output line. A print
position occupies one byte, regardless of the character set in use.
number is an integer that corresponds to a print position between the left and right
margins. The default is 1.
You may tab backwards (specify a print position earlier in the line than the current
print position), but if you overlap print items, the most recent item you specify
overwrites older ones (or portions of older ones).