SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
O-9
Considerations—OUT_REPORT
The level 3 spooling options (and the defaults SQLCI uses when you open a
spooler file) are:
For more information about level 3 spooling, see the Spooler Programmer's Guide.
For more information about PERUSE, see the Spooler Utilities Reference Manual.
Considerations—OUT_REPORT

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 print to the OUT file.

SQLCI writes only formatted data to the OUT_REPORT file and ejects a page
before and after each report from a SELECT.

The ENV command displays the name of the current OUT_REPORT file, in
addition to other information about the SQLCI session.
Examples—OUT_REPORT

This example sends reports to a disk file named DRAFT on the current volume and
subvolume, clearing the file before writing:
>> OUT_REPORT DRAFT CLEAR;

This 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;
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.