v
Amount
After you create and save the query, you run it as it exists and then change the query and run it again.
Query for iSeries query exercise: Creating a query
In this exercise, you create a query that lists on your display all the information in the file
NAMEADDR
in the
order the information exists in the file.
This exercise asks you to save the query you create in a library. You will probably want to use your own
library. If you do not have a library or do not know how to create one, see the person responsible for
libraries on your system.
1. Go to the Work with Queries display by typing
WRKQRY
on any command line.
2. On the Work with Queries display type a 1 (Create) for the
Option
prompt,
xxxQRY
for the
Query
prompt (using your initials instead of
xxx
), and the name of your library for the
Library
prompt.
Work with Queries
Type choices, press Enter.
Option . . . . . . .
1
1=Create, 2=Change, 3=Copy, 4=Delete
5=Display, 6=Print definition
8=Run in batch, 9=Run
Query
. . . . . . .
KJOQRY
Name, F4 for list
Library . . . . . .
YOURLIB
Name, *LIBL, F4 for list
F3=Exit
F4=Prompt
F5=Refresh
F12=Cancel
3. Press the Enter key. The Define the Query display is shown.
Define the Query
Query . . . . . . :
KJOQRY
Option . . . . . :
CREATE
Library . . . . . :
YOURLIB
CCSID . . . . . . :
37
Type options, press Enter. Press F21 to select all.
1=Select
Opt
Query Definition Option
1
Specify file selections
_
Define result fields
_
Select and sequence fields
_
Select records
_
Select sort fields
_
Select collating sequence
_
Specify report column formatting
_
Select report summary functions
_
Define report breaks
_
Select output type and output form
_
Specify processing options
F3=Exit
F5=Report
F12=Cancel
F13=Layout
F18=Files
F21=Select all
Appendix B. Practice exercise for Query for iSeries query
207
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 ...