Modify extract request
The Modify Extract Request screen shown in the following figure is displayed when you enter the M line command in Extract Reference List or Request File Member List screens.
Use this screen to modify or “clone” an existing extract request by changing the Db2 subsystem and object names from which you want to extract related data from and apply the relationships and criteria as specified in the selected extract request.
The “cloning” functionality allows you to create an extract request on one Db2 subsystem or MVS environment and then easily modify it to run on a different subsystem or MVS environment which has the same objects but with different names.
When you modify a saved extract request, File-AID/RDX displays the list of all object names in the request, including all related and unrelated Db2 and MVS objects along with any supporting files. Now you can specify new names for the listed objects defined in the extract request and save the request with a new file name.
Disguise Considerations
If there is no Disguise Criteria defined for the modified object name, File-AID/RDX applies the Disguise Criteria defined for the original object name. Of course, if there is Disguise Criteria defined for the modified object name, File-AID/RDX will use that and not the criteria defined for the original object.
Modify Extract Request
Option ===>
Current Extract process from:
SSID . . . . . .: DSN
Location. . . . .:
Enter new DB2 Subsystem ID:
SSID ===>
Location ===>
Modify Object names ===> N (Y = Yes; N = No)
ENTER to continue
Enter the information for the new Db2 subsystem, if your extract request includes Db2 objects, specify whether you also want to modify the object names in your extract request, then press ENTER to continue.
The body of this screen consists of the following fields:
Current Extract Process From Area
These fields display the Db2 subsystem ID and remote location ID as saved in the selected extract request.
SSID
Displays the Db2 subsystem ID. Blank if no Db2 objects are included.
Location
Displays the remote location ID of the Db2 subsystem.
Enter New DB2 Subsystem ID Area
Use the fields in this area to specify a new Db2 subsystem and remote location ID for the new extract request.
SSID
Prefilled with the Db2 subsystem ID of the original extract request. Type over this field to specify a different Db2 subsystem for the modified request.
Location
Specify the remote location name of the Db2 subsystem. If you specify a different SSID from the original request, you must also specify its remote location name here.
Modify Object names
Specify whether you want to modify the object names in your extract request or not.
Y
Enter Y (Yes) to modify object names in the request. File-AID/RDX displays the Modify Extract Request - Object Names panel listing all object names you can modify for the “cloned” request.
N
Enter N (No - default) if you do not want to modify object names in the request.
Modify extract request - object names
The following figure is displayed when you enter a Y in the Modify Object names field of the Modify Extract Request screen.
Modify Extract Request - Object Names
Option ===>
Primary Commands: Change, Detail, Find, Size
Line Commands: R = Restore
SSID: DSN Location:
Object Name Object Type
--------------------------------------------- ------------------------------
_ TSOID01.FRSAMP.EXTPDS EXTRACT FILE NAME
_ TSOID01.FRSAMP.EXTCRIT2 REQUEST FILE NAME
_ TSOID01.FRSAMP.RELATION RELATIONSHIP FILE NAME
_ TSOID01.VAR1M0.PROFILE PROFILE FILE NAME
_ TSOID01.FRSAMP.DISGUISE DISGUISE CONTROL FILE NAME
_ FRSAMP.ORDER_TABLE DB2 TABLE NAME
_ FRSAMP.CUSTOMER_TABLE DB2 TABLE NAME
_ FRSAMP.CONTACT_TABLE DB2 TABLE NAME
_ TSOID01.FRSAMP.CUSTOMER FILE OBJECT NAME
_ TSOID01.FRSAMP.LAYOUTS(CUSTOMER) MVS LAYOUT FILE
_ FRSAMP.ORDER_LINE_TABLE DB2 TABLE NAME
_ FRSAMP.PART_TABLE DB2 TABLE NAME
_ FRSAMP.SUPPLIER_TABLE DB2 TABLE NAME
******************************* Bottom of data ********************************
File-AID/RDX displays the list of all object names in the request, including all related and unrelated Db2 and MVS objects along with any supporting files. Now you can specify new names for the listed objects defined in the extract request. File-AID/RDX does not verify the modified object names until the “cloned” request is executed. When you have modified all the object names you wanted modified, enter the END command to save the “cloned” extract request.
SSID
Displays the Db2 subsystem ID. Blank if no Db2 objects are included.
Location
Displays the remote location ID of the Db2 subsystem.
Object Name
Lists all object names in the extract request file that you can modify. You can manually overtype the old name with the new name or you can use the CHANGE primary command to make global changes.
Object Type
Identifies the kind of object the object name represents in the extract request file. The list includes all objects to be extracted as well as all supporting files.
Supporting files are all MVS files referenced within the request; this includes the following files
- Layouts
- XREF
- Input (External) Key File
- Output Key File
- Extract File
- Extract Request File
- Disguise Control File (DCF)
- Profile data set
- Relationship File
- XREF and Layout data sets for generated layouts
- DBDLIBs
- IMS Extract JCL data set
Line Command
The following File-AID/RDX-specific line command is valid on this screen:
R (Restore original name)
Restores the original object name for the selected object.
Primary Commands
The following File-AID/RDX-specific primary commands are valid on this screen:
CHANGE (C)
Change allows global changes to be made to the object names in the extract request file. When entered, specify the values to change in the CHANGE Command Window - Modify Extract Request. File-AID/RDX will change all matching strings in the listed object names.
CHANGE Command Window
When you enter the CHANGE command, File-AID/RDX displays the CHANGE Command Window - Modify Extract Request as shown in the following figure.
CHANGE Command Window - Modify Extract Request
Command ===>
Change ALL occurrences of "from string" value to "to string"
From string ===>
To string ===>
END to process and return
Enter the Change ‘From string’ and the Change ‘To string’ values you want to change globally for all objects. Then press END to execute the CHANGE command. File-AID/RDX will change all matching strings in the listed object names.
From string
Enter the current From (old) string you want to change to the To (new) string in the object name list.
To string
Enter the To (new) string you want to replace the From (old) string with in the specified object name list.
DETAIL (D)
Expands the one-line display for each object name into a two-line display. The top line displays the new object name while the indented additional line shows the original object name. See the following figure for an example. Detail is a toggle switch so enter Detail again to return to the original format.
Modify Object Names - DETAIL Screen
Option ===> Scroll ===> PAGE
Primary Commands: Change, Detail, Find, Size
Line Commands: R = Restore
SSID: D801 Location:
New Object Name / Original Object Name
----------------------------------------------------------------------------
_ TSOID01.FRSAMP.EXTPDS
TSOID01.FRSAMP.EXTPDS
_ TSOID01.FRSAMP.EXTCRIT2
TSOID01.FRSAMP.EXTCRIT2
_ TSOID01.FRSAMP.RELATION
TSOID01.FRSAMP.RELATION
_ TSOID01.VAR1M0.PROFILE
TSOID01.VAR1M0.PROFILE
FIND (F)
Displays the FIND COMMAND window where you enter the alphanumeric string you want to search for. File-AID/RDX searches the list of object names for the first occurrence of the specified string and scrolls the list to display the first matching entry at the top of the displayed entries.
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.
Extract Reference List - Size Screen
Option ===>
Object Name Object Type
--------------------------------------------- ------------------------------
_ TSOID01.FRSAMP.EXTPDS EXTRACT FILE NAME
_ TSOID01.FRSAMP.EXTCRIT2 REQUEST FILE NAME
_ TSOID01.FRSAMP.RELATION RELATIONSHIP FILE NAME
_ TSOID01.VAR1M0.PROFILE PROFILE FILE NAME
_ TSOID01.FRSAMP.DISGUISE DISGUISE CONTROL FILE NAME
_ FRSAMP.ORDER_TABLE DB2 TABLE NAME
_ FRSAMP.CUSTOMER_TABLE DB2 TABLE NAME
_ FRSAMP.CONTACT_TABLE DB2 TABLE NAME
_ TSOID01.FRSAMP.CUSTOMER FILE OBJECT NAME
_ TSOID01.FRSAMP.LAYOUTS(CUSTOMER) MVS LAYOUT FILE
_ FRSAMP.ORDER_LINE_TABLE DB2 TABLE NAME
_ FRSAMP.PART_TABLE DB2 TABLE NAME
When you have modified all the object names you wanted modified, enter the END command to save the “cloned” extract request.
Save cloned extract request
The Save Extract Request screen shown in the following figure is displayed when you enter the END command in either the Modify Extract Request or Modify Extract Request - Object Names screen.
Save Cloned Extract Request
COMMAND ===>
Specify Extract Request File Information:
File name ===>
Member ===>
Description ===>
NOTE: Extract Request includes Relationship and Selection Criteria
CANCEL To Cancel Save Request
END to process and return
Use this screen to save the cloned extract request.
Press Enter to process the file information. The saved request will also appear in your Extract Reference List (see Extract Reference List).
The body of the Save Cloned Extract Request window consists of the following fields:
File Name
Specify the name of the file where you want to save the extract request. It is prefilled with the new object name for the extract request file you specified in the Modify Extract Request - Object Names screen. You can save the request to existing files. Existing files must conform to the format outlined for the extract request file in File-AID/RDX Extract/Load/Delete Request File.
If you specify a new file, you must specify the following allocation parameters in the Create New File screen.
Member
If the file is partitioned, specify the name of the member to contain the extract criteria.
Description
Enter a short description of the extract criteria. This description is displayed in the Extract Menu and the Extract Reference List. Using this description is a helpful way to document your extract criteria.
SAVE Confirmation
When saving an Extract, Load, or delete request File-AID/RDX checks to see if the member already exists. If the member already exists, the Save Confirmation window displays:
Save Confirmation window
Command ===>
The Following member exists and will be replaced:
Request File . . . .: 'TSOID01.FRSAMP.EXTCRIT'
Member to be saved : MVSKEY
ENTER to confirm Save and replace existing member
END return to Save Request enter a different member name
Press Enter to confirm overwriting the existing file or member name. Press End to cancel the Save request and return to the Save Extract Request panel where you can enter another file or member name.