Relationship Navigation Criteria panel

The following figure is displayed when you enter the VIEW NAVIGATION primary command in the Extract-Scope-Object-View-panel or any of the Relationship Criteria screens.

File-AID/RDX ------- Relationship Navigation Criteria --------- Row 1 from 12
Command ===>                                                  Scroll ===> CSR

Primary Commands: EXclude/Unex, Change, Find, Hide, FILter, CHEck, SIze, SOrt
                   VIew, STATus, SAMple, NAVigation, VALidate, GRaphic, REPort
    Line Commands: X = Exclude   U = Unexclude   I = Info
Driving Object: FRSAMP.ORDER_TABLE
           SSID: DSN   Location: DSNLOCAT            Navigation Criteria
Seq Object Name                                    Dir Par Sib Ind Status
---- ---------------------------------------------- --- --- --- --- ----------
0001 FRSAMP.CUSTOMER_TABLE                          -   -   -   N   Inactive
        FRSAMP.CONTACT_TABLE                         CONTCUST
0002 FRSAMP.CUSTOMER_TABLE                          -   Y   N   -
        FRSAMP.ORDER_TABLE                           CUSTOMER-ORDER RELATIONS
0003 FRSAMP.ORDER_TABLE                             Y   -   -   -
        FRSAMP.ORDER_LINE_TABLE                      ORDLORD
0004 FRSAMP.PART_TABLE                              -   Y   N   -
        FRSAMP.ORDER_LINE_TABLE                      ORDLPRT
0005 FRSAMP.PART_TABLE                              -   -   -   N   Inactive
        FRSAMP.SUPPLIER_TABLE                        SUPPPART
0006 FRSAMP.SUPPLIER_TABLE                          -   -   -   -   Excl Scope
        'TSOID01.FRSAMP.SUPPLIER'
0007 'TSOID01.FRSAMP.CUSTOMER'                      -   -   -   N   Inactive
        'TSOID01.FRSAMP.CONTACTT'

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

A message indicating how many relationships were retrieved for display
A message indicating the driving object for which these relationships were retrieved

Scrollable Display Area

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

Seq

Enter line commands in this sequence column. The sequence number represents File-AID/RDX internal sequencing of the applicable relationships for the driving object. For information about valid commands 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 Seq input field).

/Dependent

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

Navigation Criteria

Here you specify the Navigation Criteria on an individual relationship basis. Initially, they are set as specified globally on the Extract Scope Screen and cascade through all relationships starting with the driving object.

A dash (-) in one of the navigation settings indicates that it is not meaningful for this relationship. You cannot change the dash unless the navigation setting of a higher relationship changes it to a Y or N.

Important

When your profile has navigation criteria Direct set to C or P (see also Direct), all Extract Navigation Criteria fields are protected and cannot be modified during the extract specification.

To change a setting, type over the displayed value (Y or N) for each relationship:

Dir

(Direct) Y = Extract all of the dependents of the driving object and their dependents.
N = Don’t extract any of the dependents of the driving object and their dependents.

Par

(Parent) Y = Extract parents of all extracted data to maintain the integrity of the extracted data.

N = Don’t extract any of the parents of this relationship.

Sib

(Sibling) Y = Extract other dependents of the extracted parents from the same relationships.

N = Don’t extract any of the siblings of this relationship.

Ind

(Indirect) Y = Extract other dependents of the extracted parents from other relationships.

N = Don’t extract any of the indirect dependents of this relationship.

Status

Displays one of the following messages:

Message	Explanation
Excl All	This relationship is excluded from the current extract process as one of the related objects is marked to extract all of its records and not chase any of its relationships. This status is the result of the A (All) line command on the Extract-Scope-Object-View-panel screen.
Excl Miss	This relationship is excluded from the current extract process because at least one of the related objects does not exist.
Excl Scope	This relationship, with navigation (DPSI) settings of “----”, is excluded as the result of another relationship’s DPSI settings that make it impossible for the extract to navigate to this relationship. Any changes you make to this relationship directly have no affect on the extract. This includes changes to the sampling criteria and the DPSI settings as well.
Inactive	A relationship with one or more DPSI switches set to “N”, but none to “Y”, is considered inactive, but still within the scope of the extract as its DPSI settings can be changed. Note that in Object View, an object is marked excluded when all of its relationships are marked inactive.
Excl User	This relationship is excluded from the current extract process. This status is the result of the EXCLUDE primary or line command.
KEY Undef	For this relationship you still need to define an output key file with Extract Menu Option 6 - Output Key Files or exclude this relationship from the current extract process, before you can continue.
KEY Def	An output key file has been defined for this KEY relationship.
KEY Deleted	The output key file definition for this KEY relationship has been deleted.

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

For the description of the available line commands, see Line Commands.

Primary Commands

See Primary Commands for the description of the available primary commands not listed here.

CHANGE (C)

Change allows global changes to be made to the navigation criteria on a column-by-column basis. When the CHANGE command is entered with one of the available parameters DIR=Y or DIR=N, PAR=Y or PAR=N, SIB=Y or SIB=N, IND=Y or IND=N, the navigation values for all relationships are changed accordingly. When entered without parameters, specify the navigation controls to change in the CHANGE Command Window - Relationship Navigation Criteria.

CHANGE Command Window

When you enter the CHANGE command without parameters, File-AID/RDX will display the following figure.

CHANGE Command Window - Relationship Navigation Criteria

File-AID/RDX -------------- CHANGE COMMAND ------------------------
Command ===>

Extract Navigation Criteria:                  Primary command:
  Direct    ===> Y        ( Y = Yes, N = No)    Change DIRect=Y/N
  Parents   ===> Y                              Change PARent=Y/N
  Siblings ===> N                              Change SIBling=Y/N
  Indirect ===> N             Change InDirect=Y/N

END to process and return

***NOTE: Change will be applied to all qualified objects,
                     even those that are excluded or hidden.

Enter either Y or N for the Navigation criteria settings you want to change globally for all relationships.

Direct

Y = Extract all of the dependents of the driving object and their dependents.

N = Don’t extract any of the dependents of the driving object and their dependents.

Parents

Y = Extract the parent records of all extracted data to maintain the integrity of the extracted data.

Sibling

Y = Extract other dependents of the extracted parents from the same relationships.

Indirect

Y = Extract other dependents of the extracted parents from other relationships.