Add Relationships — MVS to IMS and Output Key Files
This Add Relationships screen shown in the following figure is displayed after you specified MVS file as the parent object and IMS and Output Key Files as the dependent object in the previous screen, Add Relationships — Specify Object Types or Application-Relationship-Detail.
Add Relationship Screen — MVS to KEY
Use this screen to specify the parent MVS file and the dependent Output Key File method with its record layout information and/or IMS database for the new relationship.
You have the choice to define the dependent record layout information and/or IMS database in three ways:
- with the Record Layout File name with a member name, if it is a PDS. The Record Layout File must exist.
or - with the DBD Library name and a member name. The DBD Library must exist.
or - with the DBD Library name and a DBD member name and also the Segment (Record) Layout File name with a member name, if it is a PDS. The Segment Layout File must exist.
Specify Parent File for Relationship Definition Area
Use the fields in this area to specify the MVS file that is the parent in the new relationship. When specifying patterns in the fields, File-AID for Db2 presents selection lists.
File name
Specify the MVS file name of the parent in the new relationship. To view a list of files, specify a pattern. Valid pattern character is * (see Wildcard Characters for Relationship Option).
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 either a layout member (Usage=S) or an XREF file and member (Usage=X).
Record layout file
Specify the record layout file for the MVS object that is to be the parent in the new relationship. To view a list of layout files, specify a pattern. Valid pattern character is * (see Wildcard Characters for Relationship Option).
Member name
Specify the member of the record layout file that contains the layout information for the MVS file. 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 MVS file that is to be the parent in the new relationship. To view a list of XREF files, specify a pattern. Valid pattern character is * (see Wildcard Characters for Relationship Option).
Member name
Specify the member of the XREF file that contains the layout information for the parent MVS file. 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 parent MVS file.
You only need to fill in this field when you want File-AID for Db2 to use an I/O exit routine when accessing the above MVS file. Not needed to search the relationship file.
Specify Method to Define Output Key File Relationship Area
Method
Specify which method to use for your Output Key file:
1
MVS Record Layout. Select method 1 when you have a File-AID record layout describing either the IMS segment or MVS record layout of the dependent object for which you want to create an Output Key File during an extract.
2
IMS DBD. Select method 2 when you have an IMS DBD library for which you want to establish a relationship with the parent Db2 table and for which you want to create the Output Key File during an extract.
3
Both. Select method 3 when you have a COBOL or PL/I segment record layout describing the IMS segment and an IMS DBD library for which you want to create an Output Key File during an extract.
Specify IMS/Output Key File Definition Area
Use the fields in this area to specify the record layout and/or IMS database that is the dependent in the new relationship. When specifying patterns in the fields, File-AID presents selection lists.
Record Layout File
Specify the record layout file that describes the record layout or IMS segment layout for which you want to establish a relationship with the parent Db2 table.
Member Name
Specify the member of the record layout or IMS segment layout file for which you want to establish a relationship. If you leave this field blank or enter a pattern other than an asterisk (*), File-AID displays a Member List window containing a list of members that match the specified pattern.
DBD Library
Specify the IMS DBD library for which you want to establish a relationship with the parent Db2 table.
Member
Specify the member of the DBD library for which you want to establish a relationship. If you leave this field blank or enter a pattern other than an asterisk (*), File-AID displays a Member List window containing a list of members that match the specified pattern.
Suggest Relationships when field name/type/length are identical Area
Suggest
Specify whether you want File-AID to select relationships when field and root segment name, type, and length in the parent and dependent objects are identical.
Y
Yes, File-AID will select fields and root segments with identical names, type and length for this relationship definition and present them in the following Field or Field/Segment Relationships Screen (see Relationships Screen - Column Relationships not yet defined). A message will inform you how many relationships have been suggested. You can then accept them or delete individual relationship definitions and/or add your own definitions.
N
No. File-AID will not suggest any application relationships when entering the following Field or Field/Segment Relationships Screen (see Relationships Screen - Column Relationships not yet defined).
Relationship Description Area
Description
Enter a description up to 128 characters in length of the application relationship to be created. This information is displayed in the Relationship Information screen.
After specifying all required parent and dependent information, press Enter. You then continue with the Field or Field/Segment Relationship screen to define the related MVS fields and IMS root segment, see Relationships.