SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

R-2

REPORT FOOTING Command

For more information, see Host Variables on page H-6 and the programming

manual for your host language.

REPORT FOOTING Command

REPORT FOOTING is an SQLCI report writer command that specifies text for the end

of a report.

print-item

specifies an item to print in the report footing. The form for print-item is the

same as in the DETAIL command, except that it cannot include the HEADING,

NOHEAD, or NAME clause. For more information, see DETAIL Command on

page D-47.

If you specify a column for print-item, SQL uses the value of the column in the

last detail line in the report.

CENTER

centers each line of the report footing between the left and right margins. If you

omit CENTER, the report footing starts at the left margin.

Considerations—REPORT FOOTING



A blank line separates the report footing from the body of the report. The report

footing appears above the page footing on the last page.



Each REPORT FOOTING replaces the previous REPORT FOOTING. Only one

REPORT FOOTING command is in effect at a time. When you enter a REPORT

FOOTING command, it replaces the previous one.



The Print List is limited to 4072 bytes of printed output. The output of a REPORT

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—REPORT FOOTING

This example specifies a report footing that includes both a literal and a column value: