Graphical relationship display

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.

This screen displays a graphical representation of the relationships in which the driving object 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 file 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-'FARDX.V2R0M0.FRSAMP.ZIPCODE' and Db2-PART_TABLE have no parents. They are at the top of their groups, respectively. There is one group displayed for MVS-'FARDX.V2R0M0.FRSAMP.ZIPCODE' and one group displayed for Db2-PART_TABLE

• The driving object is highlighted.

  In Graphical Relationship Display Screen, MVS-'FARDX.V2R0M0.FRSAMP.CREDIT' is the driving object 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-'FARDX.V2R0M0.FRSAMP.ZIPCODE' is a parent of Db2-CUSTOMER_TABLE. Db2-CUSTOMER_TABLE itself is a parent of MVS-'FARDX.V2R0M0.FRSAMP.CREDIT' and four other objects.

• Relationships that have been excluded from the extract are denoted by an X to the left of the dependent object name. In Graphical Relationship Display Screen, the occurrence of Db2-ORDER_LINE_TABLE under Db2-PART_TABLE has an X to the left of it. This denotes the exclusion of the PART_TABLE—ORDER_LINE_TABLE relationship from the extract.
• 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, 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 pop-up window. For more information about the I line command, see I (Relationship Information).

Graphical Relationship Display with 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, see Relationship Information Window.

Exclude Relationships (X)

Excludes the relationship on which the cursor is positioned. When you exclude a relationship, other relationships might also be excluded as a result. This occurs when you exclude a relationship and either of the tables in the excluded relationship is a parent or dependent in another relationship that cannot be linked back to the driving object in any other way.

Undo Excluded Relationships (U)

Selects the previously excluded relationship on which the cursor is positioned to be included in the extract.

Go to expanded view of dependents

Scrolls the display such that the first occurrence of the selected table is positioned at the top of the display. The first occurrence of a given table 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 the expanded display.

In Graphical Relationship Display with Option List, for example, if the cursor was positioned on the occurrence of ORDER_LINE_TABLE under 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 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 commands are valid on this screen. Enter these commands when the cursor is positioned next to a table name.

I (Relationship Information)

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

U (Unexclude)

Selects previously excluded relationships to be included in the extract.

X (Exclude)

Excludes a relationship from the extract. When you exclude a relationship, other relationships might also be excluded as a result. This occurs when you exclude a relationship and either of the objects in the excluded relationship is a parent or dependent in another relationship that cannot be linked back to the driving object in any other way. For example, assume three relationships exist as shown below and ORDER_TABLE is the driving object.

When the ORDER_LINE_TABLE to PART_TABLE relationship is excluded, the PART_TABLE to SUPPLIER_TABLE relationship will also be excluded.