Relationship information panels

The following figures are displayed when you enter the I line command on the Extract-Scope-Object-View-panel screen. Depending on whether you choose an RI or AR relationship (indicated in the Type field on the Relationship Criteria screen), File-AID/RDX displays the RI or AR version of the pop-up window. See Relationship Information Screen for a description of the fields in this window.

When you select an RI relationship with a status message, the Relationship Information window is displayed as shown in the following figure.

Extract-Menu-panel

Extract-Scope-panel

Relationship Information Window — RI Relationship Information

 File-AID/RDX               Relationship Information       DB2  Row 1 to 2 of 2
 COMMAND ===>                                              SCROLL   ===> CSR  

  Parent Name:    LOCATION.FRSAMP.ORDER_TABLE                  Type: DB2  



  Dependent Name: LOCATION.FRSAMP.ORDER_LINE_TABLE             Type: DB2  



  Relationship Details:
   Description:    RI -  ORDLORD
   Status:
   Created:        1997-08-26 16.03.11.035661                   User: TSOID01
   Last Modified   1997-08-26 16.03.11.035661                   User: TSOID01
  Parent Columns  /Type(Length)             Dependent Columns  /Type(Length)
  ----------------------------------------- ---------------------------------
  ORDER_NUMBER                                ORDER_NUM
     CHAR(6)                                     CHAR(6)
  *** End Of Columns ***                      *** End Of Columns ***

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

Relationship Information Screen—MVS to DB2 Application Relationship Information

File-AID/RDX               Relationship Information       DB2  ROW 1 TO 2 OF 2
COMMAND ===>                                              SCROLL   ===> CSR

 Parent Name:    ’FARDX.V2R0M0.FRSAMP.ZIPCODE’                Type: MVS
 Layout Dataset: FARDX.V2R0M0.FRSAMP.LAYOUT                   Mbr:  SMPZIP
 XREF Dataset:                                                Mbr:
 01 Level Name:
 Dependent Name: LOCATION.TSOID01.CUSTOMER_TABLE              Type: DB2  



Relationship Details:
 Description:    AR -  ZIPCODE TO CUSTOMER
 Status:
 Created:                                                     User:
 Last Modified                                                User:
Parent Fields   /Type(Length)             Dependent Columns  /Type(Length)
----------------------------------------- ------------------------------------
PARENT-KEY                                  CHILD-KEY
   INTEGER                                     INTEGER
*** End Of Fields ***                       *** End Of Columns ***

Use the END primary command to return to the Relationship Criteria screen.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*