IBM SC41-5210-04 manual Query for iSeries Use V5R2

Following are some suggestions for using the RUNQRY command:

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

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

vIf 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).

vIf 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:

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

vThe format of the job date.

vThe default for numeric editing for the language.

vThe system decimal positions processing value.

vThe system currency symbol.

vFile overrides may be in effect.

vThe job CCSID.

vThe Query for iSeries language installed (if the query specifies option 2 on the Select Collating Options display.

vThe printer file definition.

vThe attributes of the workstation you are using to display the report.

172Query for iSeries Use V5R2