SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-2
Considerations—PAGE FOOTING
CENTER
centers each line of the page footing between the left and right margins. If you omit
CENTER, the page footing starts at the left margin.
Considerations—PAGE FOOTING

On each page of a report, a blank line separates the page footing from the body of
the page. On the last page, the page footing prints below the report footing.

Only one PAGE FOOTING command is in effect at a time. When you enter a
PAGE FOOTING command, it replaces the previous one.

The output of the print list you specify in a PAGE FOOTING command is a logical
line, although (depending on margin settings, device widths, and use of the SKIP
clause) it might print on more than one physical line. A logical line is limited to 4072
bytes, including the field widths of all print items and the number of spaces
between items.
Example—PAGE FOOTING
This example defines a page footing with a page number and current date:
S> FOOTING "Page", PAGE_NUMBER AS I2, TAB 45,
+> "Date ", CURRENT_TIMESTAMP AS DATE *;
The footing looks like this:
Page 5 Date 11/23/94
PAGE_LENGTH Option
PAGE_LENGTH is an option of the SQLCI report writer SET LAYOUT command that
specifies the number of lines per page of the report.
ALL
prints the report without page breaks unless you specify a PAGE clause in a print
list.
The default for reports displayed on a terminal is ALL.
The default for other reports is 60.
PAGE_LENGTH { ALL }
{ number }