Running a Query for iSeries query
Running a query consists of telling Query for iSeries to use the query definition to acquire the data you
want from selected files, to organize the data into a report format, and then to either display the report,
print it, or store it in a database file.
To run a query, you can:
v
Press F5 (Report) while creating, displaying, or changing your query. This runs the query and displays
the report.
v
Choose option 2 (Run an existing query) on the Query menu.
v
Type a
1
(Run interactively) or a
2
(Run in batch) in the
Run option
prompt on the Exit This Query
display.
v
Type an 8 (Run in batch) or a 9 (Run) in the
Option
prompt on the Work with Queries display.
v
Use the Run Query (RUNQRY) command.
Using function key F5 when running a Query for iSeries query
If dependent values are
not
used in record selection tests, you can run a query at any time by pressing F5
(Report) while you are creating, changing, or displaying it. Your query runs immediately, the report is
displayed, and you can see what the report looks like and how any changes you make affect it.
Running a Query for iSeries query from the Query for iSeries menu
You can run an existing query by selecting option 2 (Run an existing query) on the Query menu. This
causes the RUNQRY (Run Query) command help display to appear. For more information on using the
RUNQRY command, see the CL Reference information in the iSeries Information Center and “Running a
Query for iSeries query using the RUNQRY command” on page 171 of this book.
Running a Query for iSeries query from the Exit This Query display
When you finish creating or changing a query, the Exit This Query display is shown.
Exit This Query
Type choices, press Enter.
Save definition . . .
Y
Y=Yes, N=No
Run option . . . . . .
1
1=Run interactively
2=Run in batch
3=Do not run
For a saved definition:
Query . . . . . . .
__________
Name
Library . . . . .
QGPL
Name, F4 for list
Text
. . . . . . .
_______________________________________
Authority . . . . .
*LIBCRTAUT
*LIBCRTAUT, *CHANGE, *ALL
*EXCLUDE, *USE
authorization list name
F4=Prompt
F5=Report
F12=Cancel
F13=Layout
F14=Define the query
Query assumes that you want to save your query, so it usually supplies a
Y
(Yes) in response to the
Save
definition
prompt.
Run option
is a profile option, and whatever you selected the last time you exited a
query is the default until you select a different value. However, Query supplies a
3
(Do not run) for the
Run
option
prompt when your query has an error.
Chapter 15. Exiting and running a Query for iSeries query
169
|
|
|
|
Summary of Contents for @server iSeries
Page 1: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Page 2: ......
Page 3: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Page 12: ...x Query for iSeries Use V5R2 ...
Page 14: ...2 Query for iSeries Use V5R2 ...
Page 32: ...20 Query for iSeries Use V5R2 ...
Page 38: ...26 Query for iSeries Use V5R2 ...
Page 44: ...32 Query for iSeries Use V5R2 ...
Page 116: ...104 Query for iSeries Use V5R2 ...
Page 122: ...110 Query for iSeries Use V5R2 ...
Page 146: ...134 Query for iSeries Use V5R2 ...
Page 150: ...138 Query for iSeries Use V5R2 ...
Page 174: ...162 Query for iSeries Use V5R2 ...
Page 178: ...166 Query for iSeries Use V5R2 ...
Page 196: ...184 Query for iSeries Use V5R2 ...
Page 198: ...186 Query for iSeries Use V5R2 ...
Page 204: ...192 Query for iSeries Use V5R2 ...
Page 205: ...Part 4 Appendixes Copyright IBM Corp 2000 2002 193 ...
Page 206: ...194 Query for iSeries Use V5R2 ...
Page 210: ...198 Query for iSeries Use V5R2 ...
Page 242: ...230 Query for iSeries Use V5R2 ...
Page 256: ...244 Query for iSeries Use V5R2 ...
Page 270: ...258 Query for iSeries Use V5R2 ...
Page 272: ...260 Query for iSeries Use V5R2 ...
Page 292: ...280 Query for iSeries Use V5R2 ...
Page 293: ......
Page 294: ... Printed in U S A SC41 5210 04 ...