IBM SC41-5210-04 manual Press the Enter key. The Select Records display is shown, Change

		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:

212Query for iSeries Use V5R2