Step 4—Specifying extract information for MVS file
File-AID/RDX displays the the following figure when you enter the MVS primary command on Extract - DB2 Driving Object or your profile specifies MVS as the default object type. All input fields on this panel are prefilled with values from your current profile.
Extract - MVS Driving Object
OPTION ===> E SITE Profile: RDXQUICK
Primary Commands: DB2 driving object, Edit JCL, Go to submit job
Specify file to drive the extract process from:
File ===> FRSAMP.ORDERTAB
Optional File Information:
Record layout usage ===> S (S = Single; X = XREF)
Record layout file ===> FRSAMP.LAYOUTS
Member name ===> (Blank or pattern for member list)
XREF file ===> FRSAMP.XREF
Member name ===> (Blank or pattern for member list)
Specify Extract Options:
Edit Object Selection Criteria ===> Y (Y = Yes; N = No) *None*
Specify Extract "TO" File Information:
File Name ===> FRSAMP.QUICKMVS
Edit Data Privacy Spec ===> N (Y = Yes; N = No) *None*
Relationship information stored in:
File Name ===> FRSAMP.RELATION
To specify extract information: | |
|---|---|
In this field… | Do the following: |
Command | Type E to review the extract JCL after you complete specifying the selection criteria for the driving object. |
File | Type FRSAMP.ORDERTAB |
Record layout usage | Type S |
Record layout file | Type FRSAMP.LAYOUTS |
Edit Object Selection Criteria | Type Y, so you can enter selection criteria for the driving object |
File name | Type FRSAMP.QUICKMVS, if different from the extract file specified in your FRSAMPQK profile. |
Edit Data Privacy Spec | Type N if the current value is *None*. Type Y if the current value is other than *None* and set the Disguise Extract File value to 3 (No) in the Data Privacy Specification panel. |
File name | Type FRSAMP.RELATION, if different from the relationship file specified in your FRSAMPQK profile. |
Press Enter | File-AID/RDX continues with the MVS Selection Criteria Menu. |
Field Names and Descriptions
The following list describes all of the fields on this screen.
FIELD | DESCRIPTION | |
|---|---|---|
File | Specify the MVS file name of the object from which you want to extract related data. To view a list of files, specify a pattern. If you specify a pattern, the “Catalog Utility File List” is displayed. | |
Record layout usage | Indicate whether a single record layout (usage "S"), or an XREF (usage "X") had been used to define the selection criteria. Only needed when no relationships have been defined for the MVS file. | |
Record layout file | Specify the record layout file for the MVS object from which you want to extract related data. To view a list of layout files, specify a pattern. | |
Member name | Specify the member of the record layout file that contains the layout information for the MVS object. Leave blank or use a pattern to narrow the search. | |
XREF file | Only needed if layout usage is X. Specify the XREF file name for the MVS object from which you want to extract related data. | |
Member name | Specify the member of the XREF file that contains the layout information for the MVS object. Leave blank or use a pattern to narrow the search. | |
Edit Object Selection Criteria | Enter Yes so you can specify selection criteria for the driving object. File-AID/RDX will display the MVS Selection Criteria Menu screen when you press Enter. Enter No to extract all records from the driving object. | |
File name | (Extract file) Specify the name of the file to which data will be extracted. Include the member name (in parentheses) when the file is a PDS. | |
Edit Data Privacy Spec | Specify whether you want to change the current data privacy specifications. When data privacy has been specified, File-AID/RDX will disguise the extracted data as part of the extract batch job according to the disguise criteria defined in the Disguise Control file (DCF) or in the Dynamic Privacy Rules Project (DPR). When you enter Y, File-AID/RDX will display the “Data Privacy Specification” screen so you can change the current setting. | |
File name | (Relationship file) Specify the name of the file that contains the referential integrity and application relationship information you want to use for the extract process. | |
Primary Commands
The following File-AID/RDX-specific primary commands are valid on this screen:.
COMMAND | DESCRIPTION |
|---|---|
EDIT (E) | Displays the JCL for this extract request. File-AID/RDX shows the Generated JCL panel where you can review and modify the extract JCL. |
GO (G) | Submits this extract request. Before issuing the GO command, make sure you have completed all the extract information. |
DB2 (D) | Switches from this panel to the single panel Extract - DB2 Driving Object prefilled with the applicable information from your current profile. See Extract - DB2 Driving Object. |
Related topics