SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

P-1

PAGE_COUNT Option

PAGE COUNT is an option of the SQLCI report writer SET LAYOUT command that

specifies the maximum number of pages for a printed report.

number

is an integer in the range 1 through 32,767 that specifies the number of pages to

print.

ALL

specifies printing the entire report.

The default is ALL.

Consideration—PAGE_COUNT

After the report writer prints the maximum number of pages, SQLCI terminates the

SELECT command that retrieved the information for the report.

Example—PAGE_COUNT

This example limits reports to 40 pages:

>> SET LAYOUT PAGE_COUNT 40;

PAGE FOOTING Command

PAGE FOOTING is an SQLCI report writer command that specifies text for the bottom

of each report page.

print-item

specifies an item to print in the page 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 on the page.

PAGE_COUNT { number }

{ ALL }

[PAGE] FOOTING print-item[,print-item]...[ CENTER ] ;