Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
The PAGENUM option holds the current page number of output. You can use PAGENUM with PAGEPRG to produce the page number on each page of a report. The PAGENUM option is meaningful only when PAGING is set to YES
and only for output from statements such as REPORT and LISTNAMES.
Data type
INTEGER
Syntax
PAGENUM = n
Arguments
An integer expression that specifies the page number to use for the next page of output. The default is 1
.
Notes
When you are sending output to the default outfile, set both PAGENUM and LINENUM to 1 whenever you want to produce a report starting on page 1. You can set these options in the initialization section of your report program. When you use an OUTFILE command to send output to a file, PAGENUM is automatically set to 1
.
The value of PAGENUM is incremented automatically when the last line of output has been generated on a page. When you set PAGENUM when an output page is only partially full, the value of PAGENUM will be incremented by 1 before the next page is produced. This means you usually have to set PAGENUM to a value of one less than the number you want to show on the following page.
When you set PAGING to NO
, PAGENUM stops counting and keeps its last value. When you reset PAGING to YES
, PAGENUM resumes counting at the page number where it left off.
When you use the OUTFILE command to direct output to a file, PAGENUM is set to 1
for the file. When you use the OUTFILE command with the EOF keyword to redirect output to the default outfile, PAGENUM will contain the number that it last held for the default outfile.
Examples
Example 19-21 Changing the Heading for Page 2
Suppose you want each page of a report to have a standard running page heading and a custom title, and pages after the first page to also have the heading "(Continued)". You can define a page heading program called report.head
that uses the PAGENUM value to determine when to add the "(Continued)" heading.
DEFINE report.head PROGRAM PROGRAM STDHDR BLANK PAGING = YES HEADING WIDTH LSIZE CENTER 'Annual Sales Report' BLANK IF PAGENUM GT 1 THEN HEADING WIDTH LSIZE CENTER '(Continued)' BLANK END
In your report program, set the PAGEPRG option to use the report.head
program.
PAGEPRG = 'report.head'
When you run the report program, each page after the first page starts with a heading such as the following.
15JAN95 15:05:16 Page 2 Annual Sales Report (Continued)