IBM ISERIES SC41-5210-04, User Manual

Page: 46 / 294

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
Mem ber . . . . . . . . . *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.
34
Query for iSeries Use V5R2