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........ QNAME Name, F4 for list
Library...... YOURLIB Name, *LIBL, F4 for list
F3=Exit F4=Prompt F5=Refresh F12=Cancel
(C) COPYRIGHT IBM CORP. 1988, 1991
4. On the Define the Query display, select definition steps Select and sequence fields,Select records,
Select sort fields,Specify report column formatting,Select report summary functions, and Define
report breaks by typinga1totheleftof each of them. (Notice that Specify file selections is already
selected for you.) Press the Enter key.
Define the Query
Query......: QNAME 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
1 Select and sequence fields
1 Select records
1 Select sort fields
Select collating sequence
1 Specify report column formatting
1 Select report summary functions
1 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
Query presents the selected definition step displays to you in the order in which they are listed on the
Define the Query display.
5. On the Specify File Selections display, which is the first display shown after the Define the Query
display, type QRYFILE in the File prompt and QGPL in the Library prompt. The Member and Format
prompts already are filled in for you. Press the Enter key.
Appendix B. Practice exercise for Query for iSeries query 217