Relationship information panels
The following figures are displayed when you enter the I line command on the .Extract Scope - Object View 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.
Relationship Information Window — RI Relationship Information
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
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.