Add Relationships — Db2 to IMS and Output Key Files

This Add Relationships screen shown in the following figure is displayed after you specified Db2 table as parent object and IMS and Output Key Files as dependent object in the previous screen, Add Relationships — Specify Object Types or Application-Relationship-Detail.

Add Relationships Screen — DB2 to KEY

Use this screen to specify the Db2 parent table 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 DB2 Table for Relationship Definition Area

Use the fields in this area to specify the Db2 table that is the parent in the new relationship. When specifying patterns in the fields, File-AID for Db2 presents selection lists.

SSID

Specify the Db2 subsystem ID of the Db2 subsystem on which the table resides for which you want to add relationship information.

Location

Specify the Db2 remote location ID of the Db2 subsystem on which the table resides for which you want to add an application relationship.

Creator

Specify the authorization ID of the owner of the table for which you want to add an application relationship. To view a list of tables, specify a pattern. Valid pattern characters are %, _, and * (see Wildcard Characters for Relationship Option).

Table Name

Specify the name of the Db2 object (table or view) that is to be the parent table in the new application relationship. To view a list of tables, specify a pattern. Valid pattern characters are %, _, and * (see Wildcard Characters for Relationship Option).

Specify Method to Define Output Key File Relationship Area

Method

Specify which method to use for your IMS/Output Key File relationship definition:

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.

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.

Both. Select method 3 when you have a File-AID record layout describing either 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 column and field name/type/length are identical Area

Suggest

Specify whether you want File-AID to select relationships when column, field or segment name, type, and length in the parent and dependent objects are identical.

Yes, File-AID will select columns with identical names, type and length for this relationship definition and present them in the following Column/Field or Column/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.

No. File-AID will not suggest any application relationships when entering the following Column/Field or Column/Segment Relationships Screen (see Relationships Screen - Column Relationships not yet defined).

Important

When parent and dependent objects are the same object, File-AID will bypass the automatic suggest functions as all columns/fields would be suggested. You can still issue the SUGGEST primary command in the Column/Field or Column/Segment Relationships screen. Remember, File-AID only allows up to 20 Column/Field relationship definitions.

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 Column/Field or Column/Segment Relationship screen to define the related Db2 columns and Output Key File layout or IMS root segment, see Relationships.