SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-49
DETAIL Command
NAME detail-alias
specifies an SQL identifier unique among column names in the select list as the
detail alias for the print item.
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 with 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-16). 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.