MVS relationship facilitator

The following figure is displayed when you select Option 1, Relationships, from the File-AID/RDX Primary Option Menu and your profile specifies MVS as the default driving object type (see also Default driving object type). The MVS Relationship Facilitator screen also appears when you enter the MVS command in the Db2 Relationship Facilitator screen.

MVS Relationship Facilitator

File-AID/RDX -------- MVS Relationship Facilitator -------------------------
Option ===>                                           TSOID01 Profile: A1

Primary commands: menu-option, DB2 Relationship Facilitator

    1 BROWSE ALL       - Browse all existing Relationships
    2 EDIT AR          - Edit existing Application Relationships
    3 ADD AR           - Add new Application Relationships
    4 LIST RDX         - List MVS objects from RDX Relationship File
    A ALLOCATE         - Allocate Relationship File
    P PRINT            - Print the Relationship File


Specify a File Name or Pattern:
  File name              ===> 'TSOID01.FRSAMP.*'
  Record layout usage    ===> S          (S = Single; X = XREF;)
  Record layout file     ===>
  Member name            ===>            (Blank or pattern for member list)
  XREF file name         ===>
  Member name            ===>
  I/O exit name          ===>

Specify Relationship Information:
   File name             ===> FRSAMP.RELATION

Menu Options

The following File-AID/RDX-specific menu options are valid on this screen:

1 - Browse All

Browse Relationship File. Select Option 1 to search the relationship file for previously stored relationships that match the specified object.

Option 1, Browse All, enables you to view a list of all objects defined to your relationship file that are “related” to the object (MVS file or Db2 table or view) you specify. You can then select a single relationship about which you want to view detailed information from the list. For more information, see Relationship Detail.

When browsing existing relationships you can also modify, delete, and add new application relationships.

2 - Edit AR

Edit Application Relationships. Select Option 2 to search the relationship file for previously stored application relationships.

Option 2, Edit AR, enables you to view a list of all objects defined to your relationship file that are “related” to the object (MVS file or Db2 table or view) you specify. From the list, you can then select a single relationship about which you want to view detailed information. For more information, see Application Relationship Detail.

3 - Add AR

Add Application Relationship. Select Option 3 to add an application relationship. Displays the Add Relationships — Specify Object Types so you can specify the parent and dependent object types for the new relationship. See Add Relationships — Specify Object Types.

4 - List RDX

(Default) List all MVS objects from Relationship File. Select Option 4 to search the relationship file for matching objects.

Option 4, List RDX, enables you to view a list of all objects defined to your relationship file that “match” the object specification. See MVS-Object-List.

A - Allocate

Displays the Allocate Relationship File panel where you can allocate a new relationship file. The File-AID/RDX relationship file is the repository that stores the RI and AR relationship definition so you can extract related data.

P - Print

Print Relationships. Enables you to print a formatted report that contains information from the File-AID/RDX relationship file that you specify. You can also save this report to an existing or new file.

Specify a File Name or Pattern Area

Use the fields in this area to specify the MVS file for which you want to retrieve or add relationship information from the relationship file. When specifying patterns in the fields, File-AID/RDX presents selection lists.

File Name

Specify the MVS file name of the object for which you want to view relationship information. To view a list of files, specify a pattern. Valid pattern character is * (see Pattern Characters).

If you leave this field blank and you specify a pattern in the Record layout file or XREF file name fields together with menu options 1 or 2, File-AID/RDX searches the relationship file for any objects with a matching layout or XREF definition.

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 for which you want to view relationship information. To view a list of layout files, specify a pattern. Valid pattern character is * (see Pattern Characters).

Member name

Specify the member of the record layout file that contains the layout information for the 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 MVS object for which you want to view relationship information. To view a list of XREF files, specify a pattern. Valid pattern character is * (see Pattern Characters).

Member name

Specify the member of the XREF file that contains the layout information for the 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 MVS object for which you want to view relationship information.

You only need to fill in this field when you want File-AID/RDX to use an I/O exit routine when accessing the above MVS file. Not needed to search the relationship file.

Specify Relationship File Area

Relationship File Name

Specify the name of the File-AID/RDX relationship file that contains the relationship information you want to display. For more information about the relationship file, see Relationship File.

Primary Commands

The following File-AID/RDX-specific primary commands are valid on this screen:

DB2

Switch to the Db2 Relationship Facilitator panel to specify a Db2 driving object for your Relationship task.