Filter
Top Products
To return to the complete list of file names, blank out this prompt (or put an * in it) and press the Enter
key.
To move (position) the list of file names so that it starts with a particular name, move the cursor to the
Position to prompt and type all of the characters or one or more of the starting characters in the name you
want, and press the Enter key. (Do not add an * after the starting characters in this prompt.) If a specific
library name is used in the Library prompt, Query moves the list so that the first position shown contains
the first file name that starts with the characters you typed.
If there is no file name in the list that starts with those characters, Query moves the list to the name
closest to, and in front of, the position where the name would have appeared. If a special library name or
generic library name is used in the Library prompt, the list is repositioned only if the Position to prompt
value exactly matches a complete file name.
Use F11 to alternate between showing a list of only file names to showing a list of both file names and text
describing the files.
Once you have located the files you want, type a 1 beside each file name (if more than one is allowed),
including the file name in the top position in the list. If you are selecting multiple files, you can select as
many 32 files, including those previously selected for this query. Note that if join logical files are used, you
are only able to select less than 32 files because each file used in the join logical file is counted as one of
the 32 files. For example, if three physical files were joined into one join logical file, this join logical file is
counted as three files, not one.
After you have made your file selections, press the Enter key to return to the Specify File Selections
display. All the files you selected are added to the file selections, if any, that were there previously. (Any
blanked out file selections are filled in first and new ones are added at the end as needed.) The files are
added, each with its own group of file selection prompts, in the same order as they existed on the Select
File display. They are also assigned file IDs to match the number of the file selection or, if that number is
taken, to the lowest possible value that is available in the range of T01 through T32, which you can
change if you wish.
Selecting file members on the Query for iSeries Select Member display
The Select Member display appears when you position the cursor on the Member prompt of a display and
press F4 (Prompt). The Select Member display shows you a list of members and allows you to select the
one from which your query can obtain data or the one to which the output from your query is received.
This display appears only when you are creating or changing a query definition.
Chapter 4. Specifying and selecting files for a Query for iSeries query 39