IBM SC41-5210-04 manual 145, =Printer =Database file

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:

vFor 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.

vFor 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