NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
R-2
REPORT FOOTING Command
:host-identifier
is a host variable of SQL type CHAR or VARCHAR that contains the statement
name as declared in the host program. host-identifier must conform to the
naming conventions of the host language.
For more information, see Host Variables
on page H-5 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. (See DETAIL Command
on page D-43 for more
information.)
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
•
Placement of footing line
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, 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.
REPORT FOOTING print-item [,print-item]...[ CENTER ] ;