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
Содержание ISERIES SC41-5210-04
Страница 1: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Страница 2: ......
Страница 3: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Страница 12: ...x Query for iSeries Use V5R2 ...
Страница 14: ...2 Query for iSeries Use V5R2 ...
Страница 18: ...Figure 3 Major Tasks on the Query Menu and the Work with Queries Display 6 Query for iSeries Use V5R2 ...
Страница 32: ...20 Query for iSeries Use V5R2 ...
Страница 38: ...26 Query for iSeries Use V5R2 ...
Страница 44: ...32 Query for iSeries Use V5R2 ...
Страница 116: ...104 Query for iSeries Use V5R2 ...
Страница 122: ...110 Query for iSeries Use V5R2 ...
Страница 146: ...134 Query for iSeries Use V5R2 ...
Страница 150: ...138 Query for iSeries Use V5R2 ...
Страница 174: ...162 Query for iSeries Use V5R2 ...
Страница 178: ...166 Query for iSeries Use V5R2 ...
Страница 196: ...184 Query for iSeries Use V5R2 ...
Страница 198: ...186 Query for iSeries Use V5R2 ...
Страница 204: ...192 Query for iSeries Use V5R2 ...
Страница 205: ...Part 4 Appendixes Copyright IBM Corp 2000 2002 193 ...
Страница 206: ...194 Query for iSeries Use V5R2 ...
Страница 210: ...198 Query for iSeries Use V5R2 ...
Страница 242: ...230 Query for iSeries Use V5R2 ...
Страница 256: ...244 Query for iSeries Use V5R2 ...
Страница 270: ...258 Query for iSeries Use V5R2 ...
Страница 272: ...260 Query for iSeries Use V5R2 ...
Страница 292: ...280 Query for iSeries Use V5R2 ...
Страница 293: ......
Страница 294: ... Printed in U S A SC41 5210 04 ...