Step 1—Selecting a delete request from the Delete Reference List


File-AID/RDX displays the Delete Reference List screen illustrated in the following figure when you select Option 4, Delete, from the File-AID/RDX Primary Option Menu and you have already executed an extract from the Extract Menu (extracts created using the Single Panel extract option are not included in the reference list).

Important

The current profile SAMPMENU specifies that your Load Reference List is the first panel when you select Option 3, Load or Option 4, Delete. If your profile specifies the REQUEST File Member List as the first panel, enter the REFERENCE primary command to switch to the Delete Reference List. 

File-AID/RDX

 places an entry into the Delete Reference List as soon as an extract completes.

The reference list for Delete includes all entries of the Load reference list plus all existing Delete requests. When selecting a load request for the delete process, File-AID/RDX uses only the extract file name from the selected list entry to start the on-line delete process (the selected request entry must be a valid load or delete request).

File-AID/RDX adds a delete request to the list when a delete request is saved from the Delete Processing Options screen.

Important

A disguised extract file cannot be used as input to the delete process. If you disguised the extract request EXTMENU you created in Extract—With User Profile SAMPMENU, you can use the extract file you created in Extract—With User Profile FRSAMPQK. Enter the NEW command instead and then specify the name of the extract file (FRSAMP.QUICKEXT or FRSAMP.QUICKMVS).

Delete Reference List

 File-AID/RDX -------------  Delete Reference List  ----------- Row 1 to 1 of 1
 Command ===>                                                  Scroll ===> CSR  
                                                                               
 Primary Commands: New, Find, Size, Detail, REQuest                            
    Line Commands: G = Go   S = Select                                          
                   I = Info D = Delete from list L = Lock U = Unlock            
                                                                               
   Request  Extract File Name                                      RT L YY/MM/DD
   -------- ------------------------------------------------------ -- - --------
 S          TSOID01.FRSAMP.EXTMENU                                 L    02/04/02
 ******************************* Bottom of data ********************************






Select the extract file to be used to delete records from the source files:

In this field…

Do the following:

Line Command

Type an S next to FRSAMP.EXTMENU..

Press Enter

File-AID/RDX displays the Delete Confirmation screen.

Field Names and Descriptions

The following list describes all of the fields on this screen.

FIELD

DESCRIPTION

Request

Name of the load request (member name in the saved load request file). A blank entry means the request was saved to a sequential file or that it is an automatic entry after executing an extract.

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 load request type:

D

Delete only request.

EL

Extract with Continue to Load request. When selected in the Delete Reference List only the delete will be performed.

L

Load only 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 load request was last saved or the extract was completed. The list entries are ordered with the most recent date placed on top of the list.

Primary Commands

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

COMMAND

DESCRIPTION

FIND (F)

Searches the member 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.

NEW (N)

Starts a delete request from an existing extract file or tape. Use the NEW command to open extract files created with File-AID/RDX prior to Release 3.0.

REQUEST (REQ)

Opens a saved extract or load request file. File-AID/RDX uses the default value as specified in your current profile. If your profile doesn’t include a request file, File-AID/RDX prompts for one. For the delete process, File-AID/RDX only uses the name of the extract file from a saved load request to start the online delete process.

SIZE (S)

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

Line Commands

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

COMMAND

DESCRIPTION

D (Delete from list)

Removes this request from the reference list.

G (Go)

Submits this delete request without any changes. The request must be a saved delete or load request (RT must be D or L). File-AID/RDX validates the request before submitting the JCL for the delete request.

Important

The G line command is not available if the delete request includes objects with XML and/or LOB columns. Use the S line command to process the delete request.

I (Info)

Displays the “Request Details” screen, which provides vital information about the load request and the extract file, if the extract has already been run.

L (Lock)

Protect this entry from rolling off the delete reference list.

S (Select)

Selects this request and displays the Delete Confirmation screen.

U (Unlock)

Do not protect this entry from rolling off the delete reference list.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*