Add Relationships — MVS to MVS

This Add Relationships screen shown in the following figure is displayed after you specified MVS file as both parent and dependent object in the previous screen, Add Relationships — Specify Object Types or Application-Relationship-Detail.

Add Relationships Screen — MVS to MVS

image2021-3-12_12-33-17.png

Use this screen to specify the parent MVS file and the dependent MVS file for the new relationship.

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.

Important

If the file is already involved in another relationship definition, you must use the same layout, if usage=S, or use the same XREF file to add a new relationship.

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 Dependent MVS File for Relationship Definition Area

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

Important

If the file is already involved in another relationship definition, you must use the same layout, if usage=S, or use the same XREF file to add a new relationship.

File name

Specify the MVS file name of the dependent 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 dependent 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 dependent 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 dependent 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 dependent 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.

Suggest Relationships when field name/type/length are identical Area

Suggest

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

Y

Yes, File-AID for Db2 will select fields with identical names, type and length for this relationship definition and present them in the following Field 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 for Db2 will not suggest any application relationships when entering the following Field Relationships Screen (see Relationships Screen - Column Relationships not yet defined).

Important

When parent and dependent objects are the same object, File-AID for Db2 will bypass the automatic suggest functions as all columns/fields would be suggested. You can still issue the SUGGEST primary command in the Field/Column Relationships screen. Remember, File-AID for Db2 only allows up to 20 field/column 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 Field Relationship screen to define the related MVS fields, see Relationships.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*