Unrelated Object Definition panel
The following panel is displayed when you select Option 3 - Unrelated Objects on the Extract Menu and your extract request doesn’t include any unrelated objects. It is also displayed when you enter the A line command in the Unrelated Object Specification screen.
Unrelated Object Definition
Command ===>
* No unrelated objects defined *
Object Type ===> M (DB2 or MVS)
Specify DB2 Table for Object:
SSID ===> DSN (* or pattern for selection list)
Location ===> LOCATION (* or pattern for selection list)
Creator ===> TSOID01 (* or pattern for selection list)
Table Name ===> DEPT (* or pattern for selection list)
Specify MVS file for Object:
File name ===> ’TSOID01.FRSAMP.CUSTOMER’
Record layout usage ===> (S = Single; X = XREF;)
Record layout dataset ===> ’TSOID01.FRSAMP.LAYOUT’
Member name ===> (Blank or pattern for member list)
XREF file name ===>
Member name ===> (Blank or pattern for member list)
I/O Exit Name ===>
ENTER to add
Use this screen to add an object, Db2 table or MVS file, to the set of objects to be extracted. Press Enter to add an object to the list of unrelated objects and stay on this screen. Enter END after you added all unrelated objects and the Unrelated Object Specification screen will display the list of all the unrelated objects for this extract request.
The body of the Unrelated Object Definition screen consists of the following fields:
Object Type
Specify the object type of the unrelated object you want to include in the current extract set.
DB2 | Db2 table |
MVS | MVS file |
Specify DB2 Table for Object Area
Use the fields in this area to specify the unrelated Db2 table to be added to the extract set. When specifying patterns in the fields, File-AID/RDX presents the Add Unrelated Db2 Object window shown in the following figure to assist in finding the desired table(s).
SSID
Enter the Db2 subsystem ID where the unrelated table to be extracted resides. This field is prefilled and protected when other Db2 tables are already part of the extract set. All Db2 tables in an extract must reside in the same subsystem.
As long as your extract request does not include Db2 objects the Db2 subsystem ID from your current profile is prefilled, but the field is not protected.
Location
Enter the Db2 remote location ID where the unrelated table to be extracted resides. This field is prefilled and protected when other Db2 tables are already part of the extract set. All Db2 tables in an extract must reside in the same subsystem.
Creator
Specify the authorization ID of the owner of the Db2 table to be added to the extract set.
Table Name
Specify the name of the unrelated table or view you want to add to the extract set.
Specify MVS File for Object Area
Use the fields in this area to specify the unrelated MVS file you want to include in the extract set. When specifying patterns in the fields, File-AID/RDX presents selection lists.
File name
Specify the MVS file name of the unrelated object. To complete the specification of the MVS object you must also specify its record layout information.
Record layout usage
Indicate whether a single record layout (usage "S"), or an XREF (usage "X") is to be used to define the selection criteria.
You must also supply a Record Layout file and member (Usage=S) or an XREF file and member (Usage=X).
Record layout file
Specify the record layout file for the unrelated MVS object to be added to the extract set.
Member name
Specify the member of the record layout file that contains the layout information for the unrelated MVS object. Leave blank or use a pattern to select a member from a list.
XREF file name
Only needed if layout usage is X. Specify the XREF file name for the unrelated MVS object to be added to the extract set.
Member name
Specify the member of the XREF file that contains the layout information for the unrelated MVS object. Leave blank or use a pattern to select a member from a list.
I/O Exit Name
Specify the I/O Exit Name for the unrelated MVS object.
You only need to fill in this field when you want File-AID/RDX to use an IO exit routine when accessing the above MVS file.
Primary Commands
The following File-AID/RDX-specific primary commands are valid on this screen:
END
If unrelated objects have been added, END displays the Unrelated Object Specification screen, which lists all unrelated objects to be extracted. If none were added you would return to the Extract Menu.
MENU
Returns to the Extract Menu.
SQLID
Enter the SQLID primary command to change the current Db2 SQLID. Enter the SQLID command without an operand to change the current SQLID to match the current userid. Use the new-sqlid operand to specify any SQLID. See also Default SQLID.
Add Unrelated DB2 Object
The Add Unrelated Db2 Object window shown in the following figure is displayed whenever you enter an asterisk (*) or pattern in the DB2 Creator or DB2 Table Name fields of the Unrelated Object Definition panel. It displays the results of your Db2 object filter search and allows you to select all, none, or individual objects to be included in the extract request as unrelated objects.
Use this window to select the Db2 objects you want to include as unrelated objects.
Add Unrelated DB2 Object
After selecting all desired Db2 objects to be included in the unrelated object list, press END to proceed to the Unrelated Object Specification. If you press END without selecting any objects, you return to the Unrelated Object Definition panel.
Object Name
Identifies the names of the Db2 objects that match the specified object filter.
Line Commands
The following File-AID/RDX-specific line command is valid:
S (Select)
Selects and marks this object to be included in the unrelated object list. Blank out the S marker for individual objects you don’t want included in the unrelated object list. Use in conjunction with the ALL primary command to mark your selections.
Primary Commands
The following File-AID/RDX-specific primary commands are valid:
ALL
Selects and marks all objects listed in the preview to be included in the unrelated object list. Blank out the S marker for individual objects you don’t want included in the unrelated object list. Use in conjunction with the S line command to mark your selections.
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.