Filter
Top Products
Following are some suggestions for using the RUNQRY command:
v If you want to use an existing query without changing the file or files to query, specify only a query and
library name (without an input file name). This runs the query exactly as it was defined.
v If you want to run a default query on a file, specify only an input file name. This produces a report
showing the information contained in the first 500 fields of each record.
v If you want to run a changed version of an existing query, specify a query name and the appropriate
parameters to change the definition to what you want. The parameter values you specify on this
command override the corresponding values in the existing query definition, but only when the
command is processing (that is, the changes are not permanently made to the query definition).
v If you specify both a query name and an input file name, the files specified by the input file name
parameter override the file name(s) specified in the query definition. Therefore, if multiple files (and
members) are defined in the query definition and you want to change one or two of them, you must
specify *SAME for the file selections that do not change and specify the values for the ones you want to
override.
When you run a saved query you might not get the results you expected. The items in the following list
can dynamically affect how a query runs or how the data is formatted:
v The language ID or sort sequence of the job (if the query takes them from the current job) is different
than when the query was defined.
v The format of the job date.
v The default for numeric editing for the language.
v The system decimal positions processing value.
v The system currency symbol.
v File overrides may be in effect.
v The job CCSID.
v The Query for iSeries language installed (if the query specifies option 2 on the Select Collating Options
display.
v The printer file definition.
v The attributes of the workstation you are using to display the report.
172 Query for iSeries Use V5R2