Filter
Top Products
Notice that Query has already supplied a 1 for the Specify file selections option on this display. This
is because whenever you create a query, you must specify a file, but you do not have to select any
other options on this display.
4. Press the Enter key, and the Specify File Selections display is shown.
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
This display is where you tell Query what database file(s) you want to query for the data in your
report.
5. Type NAMEADDR for the File prompt, the name for the library that contains the file for the Library
prompt, and leave the Format and Member prompts as they are shown.
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
6. Press the Enter key. The Specify File Selections display is shown again with the message Select
file(s), or press Enter to confirm. displayed at the bottom.
208 Query for iSeries Use V5R2