Request File Member List panel in the Load function
Request File Member List Screen
Command ===> Scroll ===> CSR
Primary commands: New, Find, Size, REFerence
Line commands: G = Go S = Select, D = Delete R = Rename
Request File ===> FRSAMP.EXTCRIT
Member Description Changed
-------- -------------------------------------------------- ----------
_ DB2VSAM db2 to vsam extract 2004/06/01
_ MCUST0DB MVS - TSOID01.CUSTOMER.FILE 2004/08/13
_ MIKE1 Member List 2004/05/10
_ NODB2 mcust with db2 deleted 2004/01/25
_ ORDER DB2 - LOCATION.TSOID01.CUSTOMER 2004/08/30
_ PART1 Member List 2003/02/11
_ SELCUST test select customer 2002/01/28
_ TESTA test saving the criteria 2001/04/12
******************************* Bottom of data ********************************
Request File
If you didn’t specify a name with the REQUEST command, the request file name comes from your current profile. Enter a new file name to change to a different saved request file and File-AID/RDX will display its member list.
The lower part of the screen displays a listing of the file’s members.
Member
Member name in the saved extract request file. The member names are displayed in alphabetical order.
Description
Text that was entered in the Description field when the extract or load request was created. If you left the field blank File-AID/RDX sets the description to the driving object type and name.
Changed
Date when the member was last saved.
Line Commands
The following File-AID/RDX-specific line commands are valid on this screen:
D (Delete)
Delete this member from the request file. Displays the Delete Confirmation window.
Delete Confirmation window
G (Go)
Submits this load request without any changes. File-AID/RDX validates the request before submitting the JCL for the load request.
R
Rename the request member. The Rename Confirmation window allows you to enter a new name for the request file member.
Rename Confirmation window
S (Select)
Selects this load request and displays the Load Menu prefilled with all the information from this request.
V (View JCL)
Displays the JCL for this load request. File-AID/RDX shows the Generated JCL panel where you review and modify the load JCL.
Primary Commands
The following File-AID/RDX-specific primary commands are valid on this 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.
NEW (N)
Starts a new load request from an existing extract file (see Extract File Specification).
REFERENCE
opens your Load Reference List file. For more information, see Load Reference List.
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.
Request File Member List - SIZE Screen
Command ===> Scroll ===> CSR
Member Description
_ DB2VSAM db2 to vsam extract
_ MCUST0DB MVS - TSOID01.CUSTOMER.FILE
_ MIKE1 Member List
_ NODB2 mcust with db2 deleted
_ ORDER DB2 - LOCATION.TSOID01.CUSTOMER
_ PART1 Member List
_ SELCUST test select customer
_ TESTA test saving the criteria
******************************* Bottom of data ********************************
Extract File Specification
The Extract File Specification screen shown in the following figure is displayed when you enter the NEW command in either the Load Reference List or the Request File Member List Screen.
Extract File Specification
Command ===>
Please specify an Extract File or a pattern name (in order to select an
Extract File from a list).
Extract File ===> FRSAMP.EXTRACT
* * * * When the Extract File is on TAPE, a Summary File is REQUIRED. * * * *
* * * * When the Extract File is on DISK, a Summary File is OPTIONAL. * * * *
Summary File usage ===> N (N = None; E = Existing; C = Create; U = Update)
Summary File ===>
Note: Creating or updating a Summary File requires the submission of
a BATCH job. Upon completion of this batch job, the Summary File
will be available for your use.
Use this screen to specify the name of the extract file from which you want to load data and optionally, the summary file. Press ENTER to continue to the Load Menu (Summary File usage = N or E), Create New File (Summary File usage = C), or the ISPF/PDF EDIT Screen (Summary File usage = U).
Extract File
Specify the name of the File-AID/RDX extract file from which you want to load data. An asterisk (*) or pattern displays a selection list. The extract file must be in the format that File-AID/RDX creates during extract. For information about the format of the extract file, see Extract File and File-AID/RDX Extract File.
Summary File usage
Specify whether your load request should utilize the summary file. The summary file is required for extract files on tape or cartridge, it’s optional for extract files on disk. Starting with Release 4.8 of File-AID/RDX, a summary file is created automatically during the extract to tape process (see Specify Extract “TO” File Information). For a multi-volume disk extract file, a summary file can speed up processing as it contains the header and trailer information for the extract.
N | None - Specify N when the extract file is on disk and a summary file is not needed. |
E | Existing - Specify E when the summary file for this particular extract file already exists. File-AID/RDX continues with the Load Menu. |
C | Create - Specify C when you want File-AID/RDX to create the summary file for the above extract file. File-AID/RDX then starts a batch job that extracts header and trailer information from the extract file. After the batch job to create the summary file has finished, you can continue the load request for this extract file. File-AID/RDX will display the Create New File screen to allocate the new file. |
U | Update - Specify U when you want File-AID/RDX to update an existing summary file for the above extract file. File-AID/RDX then starts a batch job that extracts header and trailer information from the extract file. After the batch job to update the summary file has finished, you can continue the load request for this extract file. |
Summary File
Specify the name for the summary file (previously known as tape control file) that contains the information for the above extract file that’s stored on tape, cartridge, or disk. The summary file is required for extract files on tape or cartridge, it’s optional for extract files on disk. If your extract file is a multi-volume file, a summary file can speed up processing as it contains the header and trailer information for the extract. An asterisk (*) or pattern displays a selection list.
Edit JCL for summary file
The ISPF/PDF EDIT Screen shown in the following figure is displayed when you select to have File-AID/RDX create or update the summary file on the Extract File Specification screen.
ISPF/PDF EDIT Screen
COMMAND ===> SCROLL ===> CSR
You are now editing the JCL that File-AID/RDX has generated to perform
the required function. Change this JCL as desired before submitting.
000004 //* XFRJSUMM
000005 //*--------------------------------------------------------------------
000006 //* THIS STEP WILL BUILD A SUMMARY FILE BY READING THE HEADER RECORDS
000007 //* AND TRAILER RECORDS OF YOUR EXTRACT FILE.
000008 //*
000009 //SUMMARY EXEC PGM=XFREXEC,REGION=4096K,
000010 // PARM=(FR,A,B)
000011 //STEPLIB DD DISP=SHR,DSN=CPWR.MXVJ170.CXVJLOAD,
000012 // DD DISP=SHR,DSN=CPWR.MXVJ170.SXVJLOAD
000013 //RDXMLIB DD DSN=CPWR.MXVJ170.CXVJMENU,DISP=SHR
000014 //EXTPARMS DD DSN=TSOID01.RDX.PARMS.1300827.T094308,DISP=SHR
000015 //EXTRACT DD DSN=TSOID01.FRSAMP.EXTRACT,
000016 // DISP=SHR
000017 //*
000018 //CONTROL DD DSN=TSOID01.RDX.SUMMARY,
000019 // DCB=(RECFM=VB,LRECL=32756,BLKSIZE=32760),
000020 // DISP=(NEW,CATLG,DELETE),
Use this screen to edit and submit the extract summary JCL generated by File-AID/RDX.
If you want to save this JCL, use the ISPF/PDF CREATE or REPLACE command before you exit this screen. Otherwise, File-AID/RDX deletes this file.
Submit this JCL to create the summary file with the extract header and trailer information. File-AID/RDX will return to the Load Reference List or Request File Member List Screen where you entered the NEW command.