Print relationship file
The Print Relationships function enables you to generate a formatted report containing the contents of a relationship file. You can print the report or write the report to a file.
Formatted relationship report screen
The following figure is displayed when you select Option P in the Db2 Relationship Facilitator or MVS Relationship Facilitator menu. You also access this screen when selecting Option 8, Print from the RDX Utilities Menu.
Formatted Relationship Report Screen
Command ===>
Specify Relationship File:
File Name ===> FRSAMP.RELATION
Use this screen to specify the relationship file for which you want to generate a report.
The body of the Formatted Relationship Report screen consists of the following field:
File Name
Specify the name of the relationship file for which you want to generate a formatted report.
Print Options Screen
The following figure is displayed when you complete the Formatted Relationship Report screen and press Enter.
Print Options Screen
Command ===>
Maximum lines per page ===> 55 (20-99)
Specify Print Options:
Printer Destination ===> LOCAL
Sysout Class ===> R
- OR -
"TO" Print file ===>
VOLSER ===>
Disposition ===> (NEW, OLD, or MOD)
If disposition is NEW, specify the following allocation parameters:
Generic Unit ===> SYSDA
Block Size ===> 141 (DSORG=PS,RECFM=VBA,LRECL=137)
Space Units ===> TRK (BLK, TRK, OR CYL)
Primary QTY ===> 10 (In above units)
Secondary QTY ===> 2 (In above units)
ENTER to view JCL
Use this screen to specify whether you want to route the report to a printer or a file. If you route the report to a file, use this screen to specify a file and its characteristics.
Maximum lines per page
Specify the maximum number of lines to be printed on each page. The value specified must be in the range 20-99.
If you want to route the report to a printer, specify appropriate values in the following two fields:
Printer Destination
Specify the destination printer.
SYSOUT Class
Specify the SYSOUT class.
If you want to route the report to a file, specify the appropriate values in the following fields:
“TO” Print file
Specify the name of the file to which the report will be written.
VOLSER
If the file specified in TO Print file is non-cataloged or new, specify the volume serial number of the file. For non-cataloged files, a volume serial number is required. For new files, a volume serial number is optional.
Disposition
Specify the disposition of the TO Print file. You can write to existing files with a disposition of OLD or MOD. Specify a disposition of NEW to create a new sequential file.
If you specify NEW in the Disposition field, you must specify the following allocation parameters:
Generic Unit
Specify the device type on which the new file will reside. The names of these devices are installation dependent.
Block Size
Specify the block size for the new file.
Space Units
Specify whether space for the new file will be allocated in blocks (BLK), tracks (TRK), or cylinders (CYL).
Primary QTY
Specify the initial number of space units that will be allocated for the new file.
Secondary QTY
Specify the number of space units that will be allocated for each secondary extent.
Edit Print JCL
The ISPF/PDF Edit screen shown in the following figure is displayed when you pressed Enter on the Print Options screen.
ISPF/PDF EDIT Screen — File-AID/RDX-generated JCL
Command ===> SCROLL ===> CSR
You are now viewing the JCL that has been generated to perform the
required function. Change this JCL as desired before submitting.
****** ***************************** Top of Data ******************************
000001 //*Your Jobcard information
000002 //*
000003 //*
000004 //* XFRJRD00
000005 //*********************************************************************
000006 //* PRINT FORMATTED REPORT
000007 //*********************************************************************
000008 //RELPRINT EXEC PGM=XFRPRINT
000009 //STEPLIB DD DISP=SHR,DSN=CPWR.MXVJ170.CXVJLOAD
000010 // DD DISP=SHR,DSN=CPWR.MXVJ170.SXVJLOAD
000011 //SYSUDUMP DD SYSOUT=*
000012 //SYSTERM DD SYSOUT=*
000014 //SYSOUT DD SYSOUT=*
000013 //SYSPRINT DD SYSOUT=(A),DEST=LOCAL,HOLD=YES
000015 //RDXPARMS DD *
000016 LINES 55
Use this screen to edit and/or submit the print JCL generated by File-AID/RDX. If you want to save this JCL, use the ISPF/PDF CREATE or REPLACE command before you exit the panel. Otherwise, File-AID/RDX deletes this file.
Submit this JCL to perform the print.
Relationship file - related objects report
The following figure is a summary of the relationships contained in the relationship file you specified on the Formatted Relationship Report screen. The report is organized such that for each object involved in a relationship you can see information about the object and its direct relationships.
Relationship File - Related Objects Report
DATE 2009-09-06
Relationship File. . : 'TSOID01.FRSAMP.RELATION' TIME 16:01:00
Type Parent to Dependent Relationships
---- ------------------------------------------------------------------------------------------------------------------------------
Parent. . .: D-LOCATION.TSOID01.ACT
RI Dependent: D-LOCATION.TSOID01.PROJACT
RELNAME: RPAA
Columns: Parent = ACTNO SMALLINT Dependent = ACTNO SMALLINT
Parent. . .: D-DSNLOCAT.FADB2610_A_________B_________C_________D_________E_________F_________G_________H_________I_________J_
________K_________L_____128.DEPT_____A_________B_________C_________D_________E_________F_________G_________H__
_______I_________J_________K_________L_____128
RI Dependent: D-DSNLOCAT.FADB2610_A_________B_________C_________D_________E_________F_________G_________H_________I_________J_
________K_________L_____128.DEPT_____A_________B_________C_________D_________E_________F_________G_________H__
_______I_________J_________K_________L_____128
RELNAME: RDD______A_________B_________C_________D_________E_________F_________G_________H_________I_________J_________K__
_____L_____128
Columns: Parent = DEPTNO___A_________B________30 CHAR(3) Dependent = ADMRDEPT_A_________B________30 CHAR(3)
AR Dependent: I-FR.IXPSAMP.DBDLIB(PORDR)
RELNAME: CUSTOMER-ORDER RELATION KEY
Columns: Parent = DEPTNO___A_________B________30 CHAR(1,3) Dependent = ORDR01 CHAR(1,3)
Parent. . .: D-DSNLOCAT.FARDX.CONTACT_TABLE
AR-C Relationship Condition:
SELECT SET=1,LAYOUT=CONTACT_TABLE-TBL
IF
FIELD_NAME=STATE,
POSITION=130,LENGTH=2,OPERATOR=EQ,
TYPE=T,VALUE=CA
Dependent: D-DSNLOCAT.FARDX.CUSTOMER_TABLE
RELNAME: CONDITIONAL AR
Columns: Parent = CUSTOMER_NUMBER CHAR(6) Dependent = CUSTOMER_NUMBER CHAR(6)
Parent. . .: D-DSNLOCAT.FRSAMP.CUSTOMER_TABLE
RI Dependent: D-DSNLOCAT.FRSAMP.CONTACT_TABLE
RELNAME: CONTCUST
Columns: Parent = CUSTOMER_NUMBER CHAR(6) Dependent = CUSTOMER_NUMBER CHAR(6)
AR Dependent: D-DSNLOCAT.FRSAMP.ORDER_TABLE
RELNAME: CUSTOMER-ORDER RELATIONSHIP
Columns: Parent = CUSTOMER_NUMBER CHAR(6) Dependent = CUST_NUM CHAR(6)
File-AID/RDX 23.1 Relationship File - Related Objects Report PAGE 2
DATE 2009-09-06
Relationship File. . : 'TSOID01.FRSAMP.RELATION' TIME 16:01:00
Type Dependent to Parent Relationships
---- ------------------------------------------------------------------------------------------------------------------------------
Dependent .: D-DSNLOCAT.FADB2610_A_________B_________C_________D_________E_________F_________G_________H_________I_________J_
________K_________L_____128.PROJ_____A_________B_________C_________D_________E_________F_________G_________H__
_______I_________J_________K_________L_____128
RI Parent: D-DSNLOCAT.FADB2610_A_________B_________C_________D_________E_________F_________G_________H_________I_________J_
________K_________L_____128.DEPT_____A_________B_________C_________D_________E_________F_________G_________H__
_______I_________J_________K_________L_____128
Dependent .: D-DSNLOCAT.FRSAMP.CONTACT_TABLE
RI Parent: D-DSNLOCAT.FRSAMP.CUSTOMER_TABLE
Dependent .: D-DSNLOCAT.FRSAMP.ORDER_LINE_TABLE
RI Parent: D-DSNLOCAT.FRSAMP.ORDER_TABLE
Dependent .: D-DSNLOCAT.FRSAMP.ORDER_LINE_TABLE
RI Parent: D-DSNLOCAT.FRSAMP.PART_TABLE
Dependent .: D-DSNLOCAT.FRSAMP.ORDER_TABLE
AR Parent: D-DSNLOCAT.FRSAMP.CUSTOMER_TABLE
Dependent .: D-DSNLOCAT.FRSAMP.ORDER_TABLE
AR Parent: D-DSNLOCAT.FRSAMP.ORDER_TABLE
Dependent .: D-DSNLOCAT.FRSAMP.SUPPLIER_TABLE
RI Parent: D-DSNLOCAT.FRSAMP.PART_TABLE
Dependent .: I-FR.IXPSAMP.DBDLIB(PORDR)
AR Parent: D-DSNLOCAT.FADB2610_A_________B_________C_________D_________E_________F_________G_________H_________I_________J_
________K_________L_____128.DEPT_____A_________B_________C_________D_________E_________F_________G_________H__
_______I_________J_________K_________L_____128
Dependent .: M-TSOID01.FRSAMP.CONTACTT
AR Parent: M-TSOID01.FRSAMP.CUSTOMER
Dependent .: M-TSOID01.FRSAMP.ORDERLIN
AR Parent: M-TSOID01.FRSAMP.ORDERTAB
Dependent .: M-TSOID01.FRSAMP.ORDERLIN
AR Parent: M-TSOID01.FRSAMP.PART_TABLE
The report groups related objects. In the first part, the groups are made up with the parent object listed first, followed by all of its dependent (child) objects. In the second part, the groups are made up with the dependent object listed first, followed by all of its parent objects. If an object is listed more than once in a group as a parent or child, it reflects the number of relationships that exist between those objects. The groups are listed in alphabetical order.
The Formatted Relationship Report consists of the following fields:
Type
Displays the type of relationship that exists between the parent and dependent object.
RI | Referential Integrity relationship |
AR | Application Relationship |
AR-C | User-defined conditional (data driven) application relationship. Created and maintained by the user. The relationship condition (selection criteria) is printed following the parent information of the relationship. |
Parent
Name of the parent object. Db2 long object names are wrapped within the column.
Dependent
Name of the dependent object. Db2 long object names are wrapped within the column.
The parent and dependent object names are preceded by their object type:
D | Db2 object |
M | MVS object |
I | IMS and Output Key file (dependent only) |
RELNAME or Description
Displays the RELNAME for RI relationships or the defined description for application relationships (AR).
Columns
Displays the related parent and dependent columns with their column type and length.