IBM SC41-5210-04 manual Information printed for a Query for iSeries query definition

When you select option 6 (Print definition) on the Work with Queries display and press the Enter key, the query definition is printed immediately.

Information printed for a Query for iSeries query definition

The printout includes the following information:

vA header at the top of each page. This header lists information about the system you are using and when the definition was printed.

vThe query name and CCSID.

vThe library name.

vAny text about the query.

vConstants attributes (decimal point separator, date format and separator, time format and separator).

vThe processing options.

vCollating sequence information.

vAssorted warnings.

vThe file identifier(s). For each file identifier, the printout includes the following:

–The file name

–The name of the library

–The name of file member

–The record format selected for the file

vThe join tests, if more than one file is used, and the type of join used.

vAny result fields, their expressions, length and decimal positions, and column headings.

vRecord selection tests.

vSelected fields, their sequence, sort priority and sort type, and any text.

vColumn formatting and summarizing.

vAny report breaks.

vThe selected output type:

–If the report is to be printed, printer information is shown.

–If the output is to be put in a database file, database file information and the field layout are shown.

vThe form of output selected, detailed or summary-only, and wrapping specifications.

If you print the definition using option 6 (Print definition) on the Work with Queries display, the printout includes information about any output type selected for the query. For example, if database file output was selected when the query was created and the query was later changed so that the output is to be printed, the printout of the query definition would include both database file and printer information. If you print the definition using any method except option 6, only current information is printed.

If you print the query definition while using the RUNQRY command (by specifying the PRTDFN(YES) parameter), the information in the printed definition reflects any temporary changes that you specify using the RUNQRY parameters or choices that Query for iSeries resolves at run time. For example, you might specify an input file name, make changes to the record selection tests, specify a different type of output, or define your query to use the running job’s sort sequence. There might be missing information, when compared to an option 6 listing, because Query for iSeries did not need to use all the selected fields to run the query.

In addition to information about the query definition, if the query produces output to a database file, a description of the record format layout is also printed.

Chapter 16. Working with Query for iSeries query definitions 181