Controls the overall length of pages output by the LIST command.
SET PAGESIZE num
|num||Num specifies, in lines, the height of an output page.
Num can be:
an integer constant (e.g., 15, 200);
a variable, form field, menu item, or parameter that evaluates to an integer.
The PAGESIZE option is set to 24 lines by default.
The PAGESIZE option should be adjusted to suit the current output device (e.g., 66 lines for a printer, 24 lines for a terminal screen).
set output printer
set pause on
set pagesize 40
set pagewidth 120
list all Employees sorted by Department
Here, the SET PAGESIZE command (together with SET PAGEWIDTH) sets LIST output for printing in the landscape orientation.