Filter
Top Products
Define the Query
Query......: KJOQRY Option .....: CHANGE
Library.....: YOURLIB CCSID......: 37
Type options, press Enter. Press F21 to select all.
1=Select
Opt Query Definition Option
> Specify file selections
_ Define result fields
_ Select and sequence fields
1 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
6. Press the Enter key. The Select Records display is shown.
Select Records
Type comparisons, press Enter. Specify OR to start each new group.
Tests: EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...
AND/OR Field Test Value (Field, Number, or ’Characters’)
______________ _____ ______________________________
____ ______________ _____ ______________________________
____ ______________ _____ ______________________________
____ ______________ _____ ______________________________
____ ______________ _____ ______________________________
____ ______________ _____ ______________________________
Bottom
Field Text Len Dec
LASTNAME Last name 15
FIRSTNAME First name 10
ADDRESS1 Address line 1 20
ADDRESS2 Address line 2 20
CITY City 15
F3=Exit F5=Report F9=Insert F11=Display names only
F12=Cancel F13=Layout F20=Reorganize F24=More keys
The fields in the file NAMEADDR are listed on the bottom portion of this display. (If your display is not in
single-column list format, that is the Text, Len, and Dec prompts are not shown, press F11.) You can
move your cursor to any place in the list and press the Page Down key to see more field names.
7. Complete the Field, Test, and Value columns on the display as follows:
212 Query for iSeries Use V5R2