IBM SC41-5210-04 manual Choosing a file for a Query for iSeries query, First

Specify File Selections

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

File	__________	Name, F4 for		list
Library	QGPL	Name, *LIBL,		F4 for list
Member	*FIRST	Name,	*FIRST,		F4	for list
Format	*FIRST	Name,	*FIRST,		F4	for list

			BOTTOM
F3=Exit	F4=Prompt	F5=Report	F9=Add file
F12=Cancel	F13=Layout	F24=More keys

The Specify File Selections display is used to specify one or more database files that you want to query for the data in your report. You can specify as many as 32 files to be queried, and you can assign unique 3-character identifiers to each one. (You can also specify the same file twice, if you need to join it to itself; if you do, it counts as two files in the query definition. For example, you might specify the same file twice but use two different record formats.)

If you are creating or changing a query definition, you should complete all the information needed for one file selection before you start on the next one. Based on the values you enter and the key you press, Query shows you the displays you need. The order of prompting within each file selection is: file, library, member, and record format. (If you have not completed all the information in a file selection, several of the F keys will not work until you supply the needed information.)

The following special values are shown in the prompts for each file selection group when it is first shown: *FIRST (for members and record formats) and *ID (for file IDs if shown). These and others that you may specify (like *LIBL for libraries) are changed when you press the Enter key; they are changed to the actual values that will be used when the query is run. Special values for member names are not changed.

The initial value shown in the Library prompt of the first file selection group is the value that you used in the file selection step in a previous query definition. For the remainder of the file selections, the initial value is the same as is used in the first group.

Choosing a file for a Query for iSeries query

To choose a file, move the cursor to the File prompt and type the name of a file.

If you want to choose a file from a list of file names, you can press F4 (with the cursor at the File prompt). The Select File display is shown, and on this display you can choose one or more files for your query.

Note: If the File prompt is blank before you press F4, you can select multiple files from the Select File display; if it is not blank, you can select only one file.

Choosing a library for a Query for iSeries query

Because the files you want to select may be in different libraries, you can specify a different library name, generic library name, or special library name for each file selection.

34Query for iSeries Use V5R2