Relationship detail

Relationship Detail

Use this screen to view a list of all relationships associated with the specified object and to select a relationship about which you want to display detailed information with the I line command.

Other line commands and the ADD primary command allow you to add, change or delete relationships.

The Relationship Detail screen displays a scrollable list of relationships involving the object specified with a previous Browse or Edit option or line command.

A relationship will appear more than once on this screen if there is more than one relationship between a given pair of objects.

CMD

Enter line commands in this column. For information about commands that are valid for this screen, see Line Commands.

Parent/

Displays the name of the object defined as the parent in a relationship in the upper row (the row with the CMD input field).

/Dependent

Displays the name of the object defined as the dependent in a relationship in the lower row, under its parent.

Obj Type

Indicates the object type of the parent and dependent.

Rel Type

Indicates the kind of relationship that exists between the corresponding parent and dependent objects.

Status/Description

Indicates the condition of each relationship in the upper row (Status) and the RI Relationship Name if it is a Db2 RI in the lower row (RelName) or the AR description for each relationship. If there is an error for the dependent object, it will override the Description in the lower row. The status row is blank if the relationship file is consistent with the Db2 catalog for the particular relationship. for a list of possible messages, see Status/Description.

Line Commands

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

A (Add)

Adds an application relationship for this parent object. Displays the Add Relationships — Specify Object Types screen so you can specify the parent and dependent object types for the new relationship. See Add Relationships — Specify Object Types.

D (Delete)

Deletes an AR or RI relationship from the relationship file.

I (Relationship Information)

Invokes the Relationship Information screen, which displays detailed information about the selected RI or application relationship. for more information on the contents of the screen, see Relationship Information Screen.

S (Select)

Selects an AR relationship for modification and displays the Column/Field Relationships screen. Not valid for RI relationships. For more information, see Building Column/Field Relationships.

Primary Commands

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

ADD

Enter the ADD command in the COMMAND field 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.

GRAPHIC (G)

Enter the GRAPHIC command in the COMMAND field to invoke the Graphical Relationship Display screen and show RI and application relationships for the table specified on the Browse Relationship File screen. For more information on the Graphical Relationship Display screen, see Graphical Relationship Display. There are no operands associated with this command.

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.

Graphical Relationship Display

The following figure is displayed when you enter the GRAPHIC command on the Relationship Detail screen, the RI Relationship Detail screen, or the AR Relationship Detail screen.

Graphical Relationship Display Screen

Primary Command

The following File-AID/RDX-specific primary command is valid on this screen:

CREATOR

Enter the CREATOR primary command in the graphical relationship display and all Db2 objects will include their Creator ID. This command acts as a toggle command, thus, when entering the command again, Db2 objects will include their Creator ID only when there is more than one object with the same name.

Understanding the Graphical Relationship Display

The body of this screen consists of a graphical representation of the relationships in which the object you selected on the Browse Table Specification screen or Browse File Specifications screen is involved. Read the Graphical Relationship Display as follows:

• Objects are identified by their:
  • Object type, either Db2, MVS, or KEY
  • Object name
    • Db2 objects include the table or view name. The Creator name is displayed only if necessary to have a unique name or when you enter the CREATOR primary command (see CREATOR primary command).
    • MVS objects include the fully qualified file name (quoted).
    • KEY objects include the fully qualified KEY record layout file or IMS database name (quoted).

• Relationships are arranged such that each object that has no parents is at the top of a group. Each group consists of an object that has no parents, its dependents, their dependents, etc. File-AID/RDX displays one group of relationships for each object that has no parents. For example, in Graphical Relationship Display Screen, MVS-'TSOID01.FARDX2.SAMP. ZIPCODE' and DB2-PART_TABLE have no parents. They are at the top of their groups, respectively. There is one group displayed for MVS-'TSOID01. FARDX2.SAMP.ZIPCODE' and one group displayed for DB2-PART_TABLE.

  Important

  For situations involving cyclical relationships, File-AID/RDX puts the object for which the most detailed dependent display can be shown at the top of the group.

• The object you specified on the Browse Specifications screens is highlighted. In Graphical Relationship Display Screen, MVS-'TSOID01.FARDX2.SAMP.CREDIT' is the object specified and is therefore highlighted.
• Relationships are displayed as lines that connect the boxes. Lines start at the bottom of parent objects and end at the left side of dependent objects. In Graphical Relationship Display Screen, MVS-'TSOID01.FARDX2.SAMP.ZIPCODE' is a parent of DB2-CUSTOMER_TABLE. DB2-CUSTOMER_TABLE itself is a parent of MVS-'TSOID01.FARDX2.SAMP.CREDIT' and four other objects.
• Objects that are displayed more than once are denoted by an asterisk (*). In Graphical Relationship Display Screen, DB2-ORDER_LINE_TABLE is displayed with an asterisk next to it because it is displayed twice (once as a dependent of DB2-ORDER_TABLE and again as a dependent of DB2-PART_TABLE).

You can scroll UP and DOWN, LEFT and RIGHT to see information that does not fit on a single screen.

Use the TAB key to move the cursor from object name to object name. When the cursor is next to an object name, you can press ENTER to display a list of options available as shown in the following figure. In addition, you can enter the I line command to display the Relationship Information screen. for more information about the I line command, see Line Commands.

Graphical Relationship Display with Option List

Option List

To select an option from the Option List, type an S in the CMD column next to an option and press Enter.

The options in the Option List are as follows:

Display Relationship Information (I)

Displays the Relationship Information pop-up window. For more information about the Relationship Information window, see Relationship Information Screen.

Go to expanded view of dependents

Scrolls the display such that the first occurrence of the selected object is positioned at the top of the display. The first occurrence of a given object in the Graphical Relationship Display has an expanded display of its dependents (if it has any). Subsequent occurrences of a given object do not repeat expanded detail.

In Graphical Relationship Display Screen, for example, if the cursor was positioned on the occurrence of DB2-ORDER_LINE_TABLE under DB2-PART_TABLE, selecting Go to expanded view of dependents would position the first occurrence of ORDER_LINE_TABLE at the top of the display. The first occurrence of ORDER_LINE_TABLE under ORDER_TABLE would display any dependents if ORDER_LINE_TABLE had any.

Go to dependent of objectname

Scrolls the display such that the occurrence of the selected object that is a dependent of objectname is at the top of the display. Use this option to determine where the object is a dependent in other relationships.

For example, if the cursor was positioned on the second occurrence of ORDER_LINE_TABLE when you pressed ENTER, the following entry would be displayed:

Selecting this entry would position the occurrence of ORDER_LINE-TABLE under ORDER_TABLE at the top of the display. If ORDER_LINE_TABLE had additional parents, there would be an entry on the Option List for each parent.

Line Commands

The following File-AID/RDX-specific line command is valid on this screen.

I (Relationship Information)

Displays the Relationship Information screen. For more information, see Relationship Information Screen.

Relationship information screen

The Relationship Information screen contains information about the relationship you specified on the Relationship Detail screen. If there are more columns comprising the relationship than can be displayed in this screen at one time, you can scroll the Parent Columns and Dependent Columns fields using standard scrolling commands.

Depending on the object types File-AID/RDX displays slightly different information. When you select a Db2 RI relationship, the Relationship Information window is displayed as shown in the following figure.

Relationship Information Screen—RI relationship information

When you select an application relationship between an MVS and Db2 object, the Relationship Information window is displayed as shown in the following figure.

Relationship Information Screen—MVS to DB2 Application Relationship Information

When you select an MVS to MVS AR relationship, the Relationship Information screen is displayed as shown in the following figure.

Relationship Information Screen—MVS to MVS AR Relationship Information

The Relationship Information screen consists of the fields described below. Fields that vary according to relationship or object type are described under separate headings.

Parent and Dependent Object Name Area

The fields in this area provide information about the parent and dependent objects.

Parent Name

Displays the fully qualified name of the parent object according to the parent’s object type.

Type

Indicates the object type of the parent and dependent object.

DB2

Db2 table.

MVS

MVS file.

KEY

Output Key file or IMS database (dependent only).

Layout File

Displays only if parent or dependent object is an MVS file or a dependent Output Key file or IMS segment with a layout. Identifies the record layout file for the MVS object, Output Key file or IMS segment used for this relationship.

XREF File

Only displays if layout usage is X. Identifies the XREF file name for the MVS object in this relationship.

01 Level Name

Only displays for MVS object. Identifies the 01 Level name for the MVS object in this relationship.

Mbr

Displays only if parent or dependent object is an MVS file. Each Mbr field identifies the member of the record layout file or the XREF file that contains the layout information for the parent or dependent MVS object in this relationship.

Dependent Name

Displays the fully qualified name of the dependent object according to the dependent’s object type.

Relationship Details Area

The fields in this area provide information about the relationship such as the Relationship Description, the Status of the relationship, creation and modification dates. The * AR Conditional * heading indicates that it is a conditional application relationship created with the COND command. The column displays a value only for already defined relationships in the Parent portion.

Created

Displays the date and time that the relationship was created. For Db2 RI relationships it represents when it was loaded into the Db2 catalog. File-AID/RDX displays date and time in the format specified at the time of Db2 installation.

User

Displays the user ID of the person who created the AR relationship or who loaded the RI relationship into the relationship file using either the initial load batch job or with the Load RI option or line command.

Last Modified

Display date, time, and user ID indicating when the relationship was last modified and who modified it. File-AID/RDX displays date and time in the format specified at the time of Db2 installation.

Parent Columns or Parent Fields

Displays the numbers and names of the columns from the Db2 parent table or the numbers and names of the fields from the MVS parent file that are involved in the relationship.

Type(Length)

The line directly below the parent field’s or column’s name displays the field’s or column’s data type. The length of the data is displayed in parentheses immediately following the data type for CHAR, VCHAR, GRPH, VGRPH, and DEC data types only. If an extended column relationship has been defined, File-AID/RDX indicates this by displaying the start position and length of the string from the parent column in parentheses instead of the column’s length. For example, for character data types:

Indicates a string in a column with a data type of CHAR has an extended column relationship defined beginning in position 2 for a length of 3.

Dependent Columns or Dependent Fields

Displays the numbers and names of the columns from the dependent table or the numbers and names of the fields from the MVS dependent file or the dependent Output Key file or IMS segment with a layout that are involved in the relationship.

Type(Length)

The line directly below the dependent field’s or column’s name displays the field’s or column’s data type. The length of the data is displayed in parentheses immediately following the data type for CHAR, VCHAR, GRPH, VGRPH, and DEC data types only. If an extended column relationship has been defined, File-AID/RDX indicates this by displaying the start position and length of the string from the parent column in parentheses instead of the column’s length. For example, for character data types:

Indicates a string in a column with a data type of CHAR has an extended column relationship defined beginning in position 2 for a length of 3.

Root Segment

Displays the name of the Root Segment from the IMS database that correspond to the columns or fields from the parent object (See Add Relationships Screen — Db2 to KEY).