Step 10—Viewing the Db2 to MVS relationship
The relationship that you created using the Column/Field-Number line command is illustrated in the following figure. File-AID/RDX redisplays the Column Relationships screen with the new column relationship listed above the End of Related Columns screen label. Mapped Fields now includes the details of the relationship.
Column/Field Relationship Established
File-AID/RDX -------------- Column/Field Relationships ---------------------
Command ===> END SCROLL ===> CSR
Primary Command: CONDitional relationships, SUGgest Relationships
Line Commands: Field Number to Define Relationship D = Delete Relationship
Parent: DB2-DSNLOCAT.FRSAMP.SUPPLIER_TABLE
Dependent: MVS-TSOID01.FRSAMP.SUPPLIER
CMD Parent Columns Type(Length) Mapped Fields
---- ------------------------------- ------------ ----------------------------
____ 1/PART_NUMBER CHAR(6) 1/PART-NUMBER
- - - - - - - - - End of Related Columns - - - - - - - - -
____ PART_NUMBER CHAR(6)
____ SUPPLIER_CODE CHAR(4)
____ SUPPLIER_NAME CHAR(20)
____ SUPPLIER_MODEL_NUM CHAR(8)
____ WHOLESALE_PRICE DEC(9,2)
NMBR Dependent fields Type(Length)
---- ------------------------------- ------------
1 PART-NUMBER CHAR(6)
2 SUPPLIER-CODE CHAR(4)
3 SUPPLIER-NAME CHAR(20)
4 SUPPLIER-MODEL-NUM CHAR(8)
5 WHOLESALE-PRICE DEC(9,2)
6 DISCOUNT-QUANTITY DEC(9,2)
Command ===> END SCROLL ===> CSR
Primary Command: CONDitional relationships, SUGgest Relationships
Line Commands: Field Number to Define Relationship D = Delete Relationship
Parent: DB2-DSNLOCAT.FRSAMP.SUPPLIER_TABLE
Dependent: MVS-TSOID01.FRSAMP.SUPPLIER
CMD Parent Columns Type(Length) Mapped Fields
---- ------------------------------- ------------ ----------------------------
____ 1/PART_NUMBER CHAR(6) 1/PART-NUMBER
- - - - - - - - - End of Related Columns - - - - - - - - -
____ PART_NUMBER CHAR(6)
____ SUPPLIER_CODE CHAR(4)
____ SUPPLIER_NAME CHAR(20)
____ SUPPLIER_MODEL_NUM CHAR(8)
____ WHOLESALE_PRICE DEC(9,2)
NMBR Dependent fields Type(Length)
---- ------------------------------- ------------
1 PART-NUMBER CHAR(6)
2 SUPPLIER-CODE CHAR(4)
3 SUPPLIER-NAME CHAR(20)
4 SUPPLIER-MODEL-NUM CHAR(8)
5 WHOLESALE-PRICE DEC(9,2)
6 DISCOUNT-QUANTITY DEC(9,2)
After you review the information on this screen, proceed to the Application Relationship Detail screen: | |
|---|---|
In this field… | Do the following: |
COMMAND | Type the END primary command. |
Press Enter | File-AID/RDX displays the Application Relationship Detail screen. |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*