NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
O-9
Considerations—OUT_REPORT
The level 3 spooling options (and the defaults SQLCI uses when you open a spooler
file) are:
For information about level 3 spooling, see the Spooler Programmer's Guide. For
information about PERUSE, see the Spooler Utilities Reference Manual.
Considerations—OUT_REPORT
•
Reports go to OUT file or OUT_REPORT file, not both
If there is a current OUT_REPORT file, reports print to that file (and to the current
LOG file, if any), but not to the OUT file. If there is no current OUT_REPORT file,
reports then print to the OUT file.
•
Formatted data, page ejects
SQLCI writes only formatted data to the OUT_REPORT file and ejects a page
before and after each report from a SELECT.
•
Displaying the current OUT_REPORT value
The ENV command displays the name of the current OUT_REPORT file, in
addition to other information about the SQLCI session.
Examples—OUT_REPORT
•
The following example sends reports to a disk file named DRAFT on the current
volume and subvolume, clearing the file before writing:
>> OUT_REPORT DRAFT CLEAR;
•
The following example sends reports to a spooler location named $SPLSYS.#S2,
naming the report EMPLIST and printing four copies:
>> OUT_REPORT $SPLSYS.#S2 SPOOL3 COPIES 4, REPORT EMPLIST;
OVERFLOW_ CHAR OPTION
OVERFLOW_CHAR is an option of the SQLCI report writer SET STYLE command
that specifies the default filler character to print when the value of a numeric report item
is too large for its display format.
LOC #name Spooler location. Default is #DEFAULT.
FORM name Name of form. Default is blanks (no form).
REPORT name Name of report. Default is your user ID.
COPIES num Number of copies. Default is 1.
PAGESIZE
num
Lines per page in PERUSE. (Make this the same as the
PAGE_LENGTH option.) Default is 60.
OVERFLOW_CHAR “character”