Relationship Criteria panel

The following panel is displayed when you specify R in the Extract Scope Detail View field of the Extract Scope Screen or enter the VIEW STATUS primary command in the Extract-Scope-Object-View-panel or any of the Relationship Criteria screens.

Relationship Criteria

This screen displays a list of referential integrity (RI) and application (AR) relationships defined in the relationship file for the driving object.

A sequence number allows positioning directly to a specific relationship and makes it easier to see the panel changes when scrolling. The sequence number field is also the line command field.

The Relationship Name in the Status field for the dependent object makes it easier to tell the difference between multiple relationships between the same objects.

Use this screen to specify which, if any, relationships to exclude from the extract process and how many rows from dependent objects to extract from those relationships not excluded. In addition, you can request information about a specific relationship.

If there are more relationships on this list than will fit on this screen, you can scroll the list up and down using standard scrolling commands. For more information about scrolling, see Scrolling.

Fixed Display Area

In addition to the screen title, the COMMAND field, and the scroll amount input field, the top area of the screen contains the following message:

• A message indicating how many relationships were retrieved for display
• A message indicating the driving object for which these relationships were retrieved, including the Db2 subsystem and location IDs
• A message indicating the hide/filter status of the display

Scrollable Display Area

This screen area displays a list of referential integrity and application relationships containing the following columns:

Seq

The Sequence column displays the sequence number for the listed relationships for the current extract request. Enter line commands in this column. For information about valid commands for this screen, see Line Commands.

Object Name (Parent)

Displays the name of the object defined as the parent in a relationship in the upper row (the row with the Seq number).

Object Name (Dependent)

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

Status

Displays one of the following messages in the upper row:

Relationship Name

The lower, second Status row for each relationship displays the relationship name (Db2 RI RELNAME or the relationship description for application relationships).

Line Commands

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

I (Relationship Information)

Invokes the Relationship Information window. For information about the Relationship Information window, see Relationship Information Window .

U (Unexclude)

Selects a previously excluded relationship to be included in the extract. Remember, you cannot undo an excluded relationship when its link to the driving object is through another, still excluded relationship. See also X (Exclude).

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.

Primary Commands

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

CHECK (CHE)

Use the CHECK command to verify the extract paths after you made navigation changes. When the path integrity validation processing is complete, the results are displayed in the Check Extract Warning screen where you can resolve or ignore the findings. File-AID/RDX executes the CHECK command whenever it returns from the Extract Scope Detail View panels.

EXCLUDE (EX or X)

The EXCLUDE command allows to exclude all relationships or all relationships of a specified object type to be excluded from the extract. EXCLUDE without parameter displays the Exclude Command Window - Relationship View.

Use this command in conjunction with the U (Unexclude) line command or UNEXCLUDE primary command when you have a long list of relationships displayed and you want to include only a few relationships in the extract.

Enter the EXCLUDE ALL command to exclude all relationships in the list displayed on the Relationship Criteria screens from the extract.

The other parameters Db2, KEY, and MVS limit the EXCLUDE command to one of the three object types.

EXCLUDE Command Window

When you enter the EXCLUDE command without parameters, File-AID/RDX displays the Exclude Command Window - Relationship View as shown in the following figure. Select the object types you want to exclude from the extract, and optionally, hide from the display.

Exclude Command Window - Relationship View

Select the object types to exclude, then press END to exit the window.

DB2 objects

Enter Y to exclude all relationships involving Db2 objects. Enter E to exclude and hide all relationships involving Db2 objects. Enter N if you don’t want to exclude all relationships involving Db2 objects from the extract. N does not unexclude excluded relationships, use the UNEXCLUDE primary or line command.

MVS objects

Enter Y to exclude all relationships involving MVS objects. Enter E to exclude and hide all relationships involving MVS objects. Enter N if you don’t want to exclude all relationships involving MVS objects from the extract. N does not unexclude excluded relationships, use the UNEXCLUDE primary or line command.

KEY files

Enter Y to exclude all relationships involving KEY files. Enter E to exclude and hide all relationships involving KEY files. Enter N if you don’t want to exclude all relationships involving KEY files from the extract. N does not unexclude excluded relationships, use the UNEXCLUDE primary or line command.

FILTER (FIL)

The FILTER command restricts the relationships being displayed to the relationships for the object(s) that contain the specified object name string. Any relationship where the specified object is either a parent or a child will be displayed. The FILTER command can be issued to build a display that contains the relationships for multiple objects by choosing the option to retain the currently filtered list. For example, you could issue the FILTER command to display the relationships for PROJ resulting in a display of only the PROJ relationships. Then issue FILTER again, this time requesting the relationships for EMP and specifying to retain the currently filtered list. The resulting display will contain all relationships for PROJ and EMP. This is the same functionality available from the object view when the R line command is issued for multiple objects prior to the VIEW command.

FILTER Command Window

When you enter the FILTER command, File-AID/RDX will display the Filter Command Window as shown in the following figure. Enter the object for which you want to display all relationships, and specify the other filtered list options.

Filter Command Window

Specify the object name and filtered list options.

Object Name Field

Enter the name of the object for which to display all relationships.

File-AID/RDX will display all relationships for the object(s) that contain the specified object name string.

Include Creator Name

Specify whether the displayed relationships for Db2 objects should also include the objects’ creator name.

Retain Current Filtered List

Enter Y to add the specified object to the current list of displayed relationships. Enter N to clear the current filtered list and display only the relationships for the specified object.

FIND (F)

Searches the list of displayed relationships for the specified string and scrolls the list to display the first matching entry at the top of the displayed entries. Use RFind to repeat the search.

GRAPHIC (GR)

Enter the GRAPHIC command to invoke the Graphical Relationship Display screen and show RI and application relationships for the driving object. For more information on the Graphical Relationship Display screen, see Graphical Relationship Display. There are no operands associated with this command.

HIDE (H)

The HIDE command allows less data to be displayed. With the parameters INcluded and EXcluded you can hide relationships from the display so that the remaining content is more meaningful. Hide without a parameter displays the Hide Command Window. Use the RESET command to return all hidden objects to the display.

HIDE Command Window

When you enter the HIDE command without a parameter, File-AID/RDX displays the Hide Command Window as shown in the following figure. Select the object status types you want to hide from the display.

Hide Command Window

Select the object status types to hide or redisplay, then press END to exit the window.

Included

Enter Y to hide all objects/relationships that are included in the extract. Enter N to display all objects/relationships that are included in the extract.

Excluded

Enter Y to hide all objects/relationships that are excluded from the extract. Enter N to display all objects/relationships that are excluded from the extract.

NAVIGATION (NAV)

The NAVIGATION command takes you directly to the NAVIGATION format of the relationship view (see Relationship Navigation Criteria).

REPORT (REP)

Prints the logical contents of the display. This report includes all of the displayable lines formatted like the current view.

RESET (RES)

Use the RESET command to return all hidden objects to the display.

SAMPLE (SAM)

The SAMPLE command takes you directly to the SAMPLE format of the relationship view.

SIZE (SI)

Increases the scrollable area to display more entries at a time by hiding some of the screen header lines. Size is a toggle switch so enter Size again to return to the original format.

SORT (SO)

Sorts the displayed list of relationships by the specified sequence (column) name. Valid SORT sequences are:

SEQ

(sequence number)

PAR

(parent object name)

DEP

(dependent object name)

ST

(status)

DESC

(description)

STATUS (STAT)

The STATUS command switches the display to the Relationship Criteria view.

UNEXCLUDE (U)

The UNEXCLUDE command allows you to unexclude all relationships or all relationships of a specified object type to be included in the extract. UNEXCLUDE without parameter displays the Unexclude Command Window - Relationship View.

Use this command in conjunction with the X (eXclude) line command or EXCLUDE primary command when you have a long list of relationships displayed and you want to reverse a previous EXCLUDE command to include objects in the extract again.

Enter the UNEXCLUDE ALL command to undo a previous EXCLUDE command for all objects in the list displayed on the Relationship Criteria screens from the extract.

The optional parameters Db2, KEY, and MVS limit the UNEXCLUDE command to one of the three object types.

UNEXCLUDE Command Window

When you enter the UNEXCLUDE command without parameters, File-AID/RDX displays the Unexclude Command Window - Relationship View as shown in the following figure. Select the object types you want to include in the extract again (reverse a previous EXCLUDE line or primary command).

Unexclude Command Window - Relationship View

Select the object types to unexclude, then press END to exit the window.

DB2 objects

Enter Y to unexclude all relationships involving Db2 objects. Enter N if you don’t want to unexclude all relationships involving Db2 objects. N does not exclude included relationships, use the EXCLUDE primary or line command.

MVS objects

Enter Y to unexclude all relationships involving MVS objects. Enter N if you don’t want to unexclude all relationships involving MVS objects from the extract. N does not exclude included relationships, use the EXCLUDE primary or line command.

KEY files

Enter Y to unexclude all relationships involving KEY files. Enter N if you don’t want to unexclude all relationships involving KEY files from the extract. N does not exclude included relationships, use the EXCLUDE primary or line command.

VALIDATE (VAL)

The VALIDATE command validates all relationships in the current extract request against the relationship file. The message “No changes” informs you that all relationships have been successfully validated. If there are inconsistencies, the Update Saved Request Window reports the validation results and gives you the opportunity to update the saved request or reload the request as last saved.

VALIDATE corresponds to RDX Utilities Option 1, Update Saved Extract Requests, except that it executes online and only on the current request.

VIEW (VI)

The VIEW command allows you to easily switch between the object and relationship views. VIEW without any parameter displays the Extract Scope - Object View screen. VIEW with one of the parameters SAMPLE, STATUS and NAVIGATION displays the corresponding format of the relationship view.