IBM SC41-5210-04 manual Qname

	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 typing a 1 to the left of 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

1Specify file selections Define result fields

1Select and sequence fields

1Select records

1Select sort fields Select collating sequence

1Specify report column formatting

1Select report summary functions

1Define 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