IBM SC41-5210-04 manual EXAMPFILE1, EXAMPMBR1 EXAMPMBR2 EXAMPMBR3

		Select Member
File ID	. . . . . :	T01
File . . . . . . . :		EXAMPFILE1
Library	. . . . :	CUSTINV

Type option (and Member), press Enter. 1=Select

Opt Member

___________

_EXAMPMBR1

_EXAMPMBR2

_EXAMPMBR3

Bottom

F11=Display text F12=Cancel

If you came from the Specify File Selections display or Specify Dependent Value Qualifiers display, you can specify which member you want your query to get data from. If you came from the Define Database File Output display, you can specify which member you want the query data to be put into.

At the top of the display, the File ID field is shown if you came here from the Specify File Selections display. The file ID is the file identifier of the file that is shown in the File field. This file is the one for which you want to choose a member. The Library field shows the library in which the file is stored.

The names of the member that currently exist in the file shown at the top of the display are shown in the Member column. You can choose a member by either typing a 1 in the Opt column to the left of the member or by typing a member name (and a 1 in the Opt column next to it) in the first position in the list. If you specify a member name in the top position, that member must also exist at this time. If you specify *FIRST or *LAST, the member name on the previous display is changed to that value. Then, either the first or the last member that exists in the file at the time the query is run is the member that is used. If you came from the Define Database File Output display, you can also specify *FILE in the first position in the list.

You can use F11 to alternate between showing a list of only member names to showing a list of both member names and text describing the members.

When you press the Enter key on the Select Member display, the member that you specify is then shown in the Member prompt on the display that you return to. If you return to the previous display without selecting or specifying a name, the previous member name or value is not changed.

Selecting record formats on the Query for iSeries Select Record Format display

The Select Record Format display appears when you position the cursor on the Format prompt of the Specify File Selections display and press F4 (Prompt). The Select Record Format display shows you a list of record formats from which you can select the one you want your query to use with a selected file member. This display appears only when you are creating or changing a definition.

40Query for iSeries Use V5R2