Delete reference list


The Delete Reference List screen is displayed when you:

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.

In addition, whenever you have successfully executed an extract, File-AID/RDX places an entry with the extract file name into the delete reference list. However, extracts that originate from the “Single Panel Extract” function are not included in the Delete Reference List.

You can also create a new delete request with the NEW command, or open a request file with the REQUEST command to select the extract file for the delete process (the selected request entry must be a valid load request).

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

Important

The reference list is stored in your personal USER profile. If your USER profile file (‘userid.midlevlqualifier.PROFILE’) does not exist, File-AID/RDX will create your USER profile when you are saving an extract or load request.

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.

Delete Reference List

File-AID/RDX -------------  Delete Reference List  ---------  Row 1 to 6 of 6
 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
   -------- ------------------------------------------------------ -- - --------
 _          TSOID01.FRSAMP.CUSTDB.EXTRACT                               10/02/02
 _          TSOID01.FRSAMP.EXTRACT                                 L  L 10/02/01
 _ TEST3    TSOID01.FRSAMP.TEST3.EXTRACT                           D    10/02/04
 _          TSOID01.FRSAMP.PDS.EXTRACT(EXTCUST)                         09/01/24
 _ DIEBLD   TSOID01.FRSAMP.CUST.EXTRACT.NODB2                      EL L 09/01/14
 _ TEST2    TSOID01.FRSAMP.TEST2.EXTRACT                           L  L 09/01/04
 ******************************* Bottom of data ********************************

The lower part of the screen displays a listing of your recently referenced load requests. Use the S line commands to start a delete request based on the extract file specified for the selected entry.

Request

Name of the delete or load request (member name in the saved delete or 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 delete or load request type:

D

Delete only request.

EL

Extract and Continue with Load request.

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.

Line Commands

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

D (Delete from list)

Removes this request from the delete/load 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 more comprehensive information about the load request. See the following figure for an example.

Request Details

 File-AID/RDX ----------------  Request Details  -------------------------------
 Command ===>

 Request Information:                                           
   Request File Name  . : TSOID01.FRSAMP.REQUEST                  
   Member Name  . . . . : TEST3                                 
   Request Type . . . . : DELETE                                 
   Description  . . . . : FRSAMP Delete request test 3             
   Reference Date . . . : 2010/02/04     Reference Time: 00:00:07
                                                                
 Driving Object Information:                                    
   SSID . . . . . . . . :                                     
   Name . . . . . . . . :             
                                                                
 Extract Information:                                          
   Extract File Name  . : TSOID01.FRSAMP.TEST3.EXTRACT           
   Summary File Name  . :                  
   Disguise Control File:                  
   Repository Name:                  
   Project Name:                  
   Extract Date . . . . : 2010/01/03     Extract Time  : 00:00:07
                                                                
 Relationship Information:                                      
   File Name  . . . . . : TSOID01.FRSAMP.RELATION 

L (Lock)

Protects this entry from rolling off the reference list.

S (Select)

Selects this request and displays the Delete Confirmation screen prefilled with the information from the request.

U (Unlock)

Does not protect this entry from rolling off the 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 for an example. DETAIL is a toggle switch so enter DETAIL again to return to the original format.

Delete Reference List - DETAIL Screen

 File-AID/RDX -------------  Delete Reference List  ---------  Row 1 to 6 of 6
 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
   -------- ----------------------------------------------------- -- - --------
 _          TSOID01.FRSAMP.CUSTDB.EXTRACT                              04/09/02
            Description:  DB2-TSOID01.CUSTOMER
 _          TSOID01.FRSAMP.EXTRACT                                L  L 04/09/01
            Description:  DB2-FRSAMP.CUSTOMER
 _ TEST3    TSOID01.FRSAMP.TEST3.EXTRACT                          D    10/02/04
            Description:  Delete from Test3
 _          TSOID01.FRSAMP.PDS.EXTRACT(EXTCUST)                        04/08/24
            Description:   MVS-TSOID01.CUSTOMER
 _ DIEBLD   TSOID01.FRSAMP.CUST.EXTRACT.NODB2                      EL L 09/01/14
            Description:   MVS-TSOID01.ORDERTAB
 _ TEST2    TSOID01.FRSAMP.TEST2.EXTRACT                           L  L 09/01/04
            Description:   MVS-TSOID01.PARTTABL
 ******************************* Bottom of data ********************************

Find

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 delete request from an existing extract file. Use the NEW command to open extract files created with File-AID/RDX prior to Release 3.0 that don’t have any saved load requests associated with them, yet.

REQUEST (REQ)

Opens a saved request file. For more information, see Request File Member List.

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.

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.

Delete Reference List - SIZE Screen

File-AID/RDX -------------  Delete Reference List  --------- Row 1 to 6 of 6
 Command ===>                                                 Scroll ===> CSR
   Request--Extract File Name-------------------------------------RT-L-YY/MM/DD
 _          TSOID01.FRSAMP.CUSTDB.EXTRACT                               04/09/02
 _          TSOID01.FRSAMP.EXTRACT                                 L  L 04/09/01
 _ TEST3    TSOID01.FRSAMP.TEST3.EXTRACT                           D    10/02/04
 _          TSOID01.FRSAMP.PDS.EXTRACT(EXTCUST)                         04/08/24
 _ DIEBLD   TSOID01.FRSAMP.CUST.EXTRACT.NODB2                      EL L 04/08/14
 _ TEST2    TSOID01.FRSAMP.TEST2.EXTRACT                           L  L 04/08/04
 ****************************** Bottom of data ********************************

 

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