|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
The PAGESIZE option specifies the size of a page of output. The value of PAGESIZE is the number of output lines to be produced on each page. PAGESIZE is usually used in the initialization section of report programs. The PAGESIZE option is meaningful only when PAGING is set to
YES and only for output from statements such as REPORT and LISTNAMES. PAGESIZE also controls the LINELEFT option. When PAGESIZE is changed, Oracle OLAP adjusts LINELEFT accordingly.
PAGESIZE = n
INTEGER expression that specifies the number of output lines on a page; n includes the top and bottom margins (controlled by the TMARGIN and BMARGIN options). The default is 66 lines, which is suitable for printing report output on 8 1/2" by 11" paper.
Usable Output Lines with Standard Heading and Default Settings
When you use the standard heading and the default settings for the PAGESIZE, TMARGIN, and BMARGIN options, the total number of usable output lines is 61.
Output Lines Lines from PAGESIZE 66 Lines for TMARGIN - 2 Lines for the standard heading - 2 Lines for BMARGIN - 1 Lines available for output 61
Eliminating Headings and Page Breaks
You can produce pages with no headings by using the statement
PAGEPRG='NONE' or suppress page breaks entirely by using the statement
PAGING = NO.
Setting PAGESIZE for a File
To set PAGESIZE for a file, first make the file your current outfile by specifying its name in an OUTFILE statement, then set PAGESIZE to the desired value. The new value remains in effect until you reset it or until you use an OUTFILE statement to direct output to a different outfile. When you direct output to a different outfile, PAGESIZE returns to its default value of
66 for the file.
When you set PAGESIZE for the default outfile, the new value remains in effect until you reset it, regardless of intervening OUTFILE commands that send output to a file. That is, the value of PAGESIZE is automatically saved for the default outfile.