SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-4
PAGE TITLE Command
The output looks like this:
Monthly Report - 6
PAGE TITLE Command
PAGE TITLE is an SQLCI report writer command that specifies text for the top of each
report page.
print-item
specifies an item to print in the page title. 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
first detail line on the page. If a detail line is continued from the previous page, SQL
uses the value from the SELECT output row that contains the detail line data.
CENTER
centers each line of the page title between the left and right margins. If you omit
CENTER, the page title starts at the left margin.
Considerations—PAGE TITLE

A blank line separates the page title from the body of the report. On the first page,
the page title appears above the report title.

Only one PAGE TITLE command is in effect at a time. When you enter a PAGE
TITLE command, it replaces the previous one.

The output of a PAGE TITLE 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 TITLE
This example defines a title for each page of a report:
S> TITLE "----- Accounts of: ", SALESREP, " -----" CENTER;
The title looks like this:
----- Accounts of: 220 -----
[ PAGE ] TITLE print-item [,print-item]...[ CENTER ] ;