IBM SC41-5210-04 manual Create, Yourlib Ccsid

Specify File Selections

Type choices, press Enter. Press F9 to specify an additional file selection.

File	NAMEADDR	Name, F4 for	list
Library	YOURLIB	Name, *LIBL,	F4 for list
Member	*FIRST	Name, *FIRST,		F4	for list
Format	NAMEADDRR	Name, *FIRST,		F4	for list

F3=Exit	F4=Prompt	F5=Report	F9=Add file
F12=Cancel	F13=Layout	F24=More keys
Select file(s), or press Enter to confirm.

7.Press the Enter key. The Define the Query display is shown with the message Select options, or press F3 to save or run the query. displayed at the bottom.

		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

_> 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

Select options, or press F3 to save or run the query.

The Specify file selections option has a > shown in the Opt column to indicate that it is a previously defined option.

8.Press F3 (Exit). The Exit This Query display is shown.

Query supplies a Y (Yes) in the Save definition prompt and a 1 (Run interactively) in the Run option prompt because it assumes you want to both save the query definition object and run the query. Leave these defaults in both prompts.

9.Type Lists customer names and addresses for the Text prompt.

10.Type *CHANGE for the Authority prompt.

Appendix B. Practice exercise for Query for iSeries query 209