Filter
Top Products
Chapter 13. Selecting output type and output form in Query
for iSeries reports
This chapter describes how you select where you want your query output to go, and in what form you
want it to be. You can have the output displayed, printed, or put into a database file. You can also specify
that the output is to be in detailed form (which includes all of your selected records) or in summary form
(which only includes report break data as described in Chapter 12, “Defining Query for iSeries report
breaks”).
If you do not use this definition step in defining your query, the output produced by Query is shown on
your display and is in detailed form.
If you specify that your output is to be printed or stored in a database file, Query will present additional
displays so that you can define printer or database file characteristics.
Selecting the output type and form you want in Query for iSeries
reports
You can select the output device for your query by entering one of the following choices:
1=Display
The output of your query is to be shown on your display, and it can be shown in detailed or summary
form. The output is the same as that produced by F5 (Report) during query definition. For information
on how to use the Display Report display, you can press the Help key while you are displaying your
query output.
Note: If a query is run in batch, output is sent to the printer, even though display output type is
specified.
2=Printer
The output of your query is to be printed, and it can be printed in detailed or summary form. If you
select this option, the Define Printer Output display is shown when you press the Enter key. There,
you can specify the printer to be used and other characteristics of the printed output. Other displays
related to the printed output are also shown.
Note: If a query is run in batch, output may be sent to a different printer than one you specify,
depending on the default printer specifications for batch.
3=Database file
The output of your query is to be put into a database file. If you select this option, the Define
Database File Output display is shown when you press the Enter key. There, you can specify the
name of the file and member to be used to store the output and whether the output is to be added to
the file or member or is to replace existing data in the file or member.
Both the detailed and summary forms of database file output are different from displayed or printed
output:
v For detailed output to database, report break and summary function output (if defined in the query)
is ignored; only the selected records are put in the database file. Also, if you specify that output is to
a database file, the values in the line wrapping prompts are ignored; database output records are
never wrapped. Report column formatting is ignored.
v For summary output to database, Query produces a record for each defined report break, including
one for break level zero (0). Editing values on the total fields are used.
Note that database output does not contain certain report characteristics that are used for displayed or
printed reports: column headings, column spacing, line wrapping, report break formatting, or printer
© Copyright IBM Corp. 2000, 2002 145