Extract reference list to extract request

The Extract Reference List screen shown in the following figure is displayed when you:

• Select Option 2, Extract, from the File-AID/RDX Primary Option Menu and your profile set it as the first extract panel;
  or

• Enter the REFERENCE command on an “Extract Menu” panel

Use this screen to select an extract request from the list or start a new extract request. File-AID/RDX adds an extract request to the list whenever a request is saved from the Extract Menu. Extract requests that originate from the “Single Panel Extract” function are not saved to a request file and thus not included in the Extract Reference List.

You can also create a new extract request with the NEW command, or open a saved extract request file with the REQUEST command. Use the REQUEST command to open extract criteria files created with File-AID/RDX prior to Release 3.0.

For how to set the maximum number of list entries for the reference list, see Option G—Global User Defaults.

You may specify multiple line commands at a time. All line commands are processed before any primary commands. When processing multiple commands File-AID/RDX displays a message like “Processing line command 2 of 4” whenever it starts processing the next line command after the first.

Extract Reference List

The lower part of the screen displays a listing of your recently referenced extract requests. Use one of the line commands to either resubmit one of the extract requests or model a new request after it.

Request

Name of the extract request (member name in the saved extract request file or extract criteria file). A blank entry means the request was saved to a sequential file.

Extract File Name

Name of the file containing the extracted data. If saved to a PDS the member name is displayed in parentheses.

RT

Request Type. Identifies the extract request type:

E

Extract only request.

EL

Extract and Continue with Load request.

L

Locked Entry. Identifies whether the request is locked in the reference list or whether it is allowed to roll off.

blank

not protected from roll over.

L

Locked in reference list; entry will not roll off the list.

YY/MM/DD

Date when the extract request was last saved or executed. The list entries are ordered with the most recent date placed on top of the list.

Line Commands

The following File-AID/RDX-specific line commands are valid on this screen:

C (Change selection criteria & Go)

Repeat this extract request with new selection criteria for the driving object. File-AID/RDX then displays the appropriate Object Selection Criteria screen for the driving object, either Object Selection Criteria - Selective Columns, Db2 Object Selection Criteria, or Selection Criteria Menu. After you specify the new selection criteria, File-AID/RDX will submit the extract request.

D (Delete from list)

Removes this extract request from the extract reference list, but does not delete the member from the extract request file itself.

G (Go)

Submits this extract request without any changes.

I (Info)

Displays the Request Details screen, which provides more comprehensive information about the extract request. See the following figure for an example.

Request Details

L (Lock)

Protects this entry from rolling off the extract reference list.

M (Modify)

Selects this extract request, displays the Modify Extract Request panel for you to change or “clone” an existing extract request. See also Modify Extract Request.

S (Select)

Selects this extract request and displays the Extract Menu prefilled with all the information from this request. See also Extract Menu.

V (View JCL)

Displays the JCL for this extract request. File-AID/RDX shows the ISPF/PDF EDIT Screen—File-AID/RDX-generated JCL panel where you review and modify the extract JCL.

U (Unlock)

Does not protect this entry from rolling off the extract reference list.

Primary Commands

The following File-AID/RDX-specific primary commands are valid on this screen:

DETAIL (D)

Expands the one-line display for each request into a two-line display. The additional line shows the request description. See the following figure as an example. Detail is a toggle switch so enter Detail again to return to the original format.

Extract Reference List - DETAIL Screen

FIND (F)

Searches the list for the specified string and scrolls the list to display the first matching entry at the top of the displayed entries. Use RFind to repeat the search.

Find looks for matches in the request detail information for each list entry. When a match is found and is not visible in the displayed row, use the I (info) line command to display the detail information.

NEW (N)

Starts a new extract request based on your current profile. File-AID/RDX displays either the DB2 or MVS Driving Object screen as set in your profile (see Extract - Db2 Driving Object or Extract - MVS Driving Object).

You can also include one of the optional parameters, Db2 or MVS, to display the respective Driving Object screen.

REQUEST (REQ)

Opens a saved extract request file. You also use the REQuest command to open extract criteria files created with File-AID/RDX prior to Release 3.0. For more information, see Extract - Db2 Driving Object.

File-AID/RDX opens the request file specified in your current profile or prompts for the file name when none is in your profile.

SIZE (S)

Increases the scrollable area to display more entries at a time by hiding some of the screen header lines. See the following figure for an example. Size is a toggle switch, so enter Size again to return to the original format.

Extract Reference List - Size Screen