NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
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
•
Placement of footing line
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.
•
Each PAGE FOOTING replaces the previous PAGE FOOTING
Only one PAGE FOOTING command is in effect at a time. When you enter a PAGE
FOOTING command, it replaces the previous one.
•
Print list limited to 4072 bytes of printed output
The output of the print list you specify in a PAGE FOOTING command is a logical
line, even though (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.
Examples—PAGE FOOTING
•
The following 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 }