Specify MVS field subscripts
The Specify MVS Field Subscripts pop-up window shown in the following figure is displayed when you attempt to map two fields where one or both fields contain an occurrence of subscript. You then specify the bounds of the array for each subscript. File-AID/RDX supports a maximum occurrence of a three dimensional array.
Specify MVS Field Subscripts for Parent Field
This window appears only if the selected parent field contains subscripts. Use it to specify the desired value for up to three subscripts, where applicable.
Parent
Displays the name of the parent file.
Field Name
Displays the name of the parent field to be mapped.
Data Type
Displays the type of data contained in the field. The length, in parentheses, follows the data type.
Subscript 1
Specify the starting position of substring 1 in the parent field that will comprise the column/field relationship.
Subscript 2
Specify the starting position of substring 2 in the parent field that will comprise the column/field relationship.
Subscript 3
Specify the starting position of substring 3 in the parent field that will comprise the column/field relationship.
After you press Enter, you continue either with the Dependent Field Subscripts window (see the following figure), if the dependent field contains subscripts, or the Extended Field Relationship Definition window (Extended Field Relationship Definition with Field Subscripts Defined), if the parent and dependent field types qualify for Extended Field Relationship Definition, or return directly to the Field/Column Relationship screen (Extended Field Relationship with Defined Subscripted Relationship) when the relationship definition is completed.
Specify MVS Field Subscripts for Dependent Field
Use this window to specify the desired value for up to three subscripts, if applicable, for the dependent field.
Dependent
Displays the name of the dependent file.
Field Name
Displays the name of the dependent field to be mapped.
Data Type
Displays the type of data contained in the field. The length, in parentheses, follows the data type.
Subscript 1
Specify the starting position of substring 1 in the parent or dependent field that will comprise the column/field relationship.
Subscript 2
Specify the starting position of substring 2 in the parent or dependent field that will comprise the column/field relationship.
Subscript 3
Specify the starting position of substring 3 in the parent or dependent field that will comprise the column/field relationship.
After you press Enter, you continue either with the Extended Field Relationship Definition window (see the following figure), if the parent and dependent field types qualify for Extended Field Relationship Definition, or return directly to the Field/Column Relationship screen (Extended Field Relationship with Defined Subscripted Relationship) when the relationship definition is completed.
Extended Field Relationship Definition with Field Subscripts Defined
See Extended Column Relationship Definition for a description of the fields. Note that the Type(Length) field now also includes the array size and maximum length of the related elements.
Upon completion, File-AID/RDX displays the defined relationship in the Field Relationships screen as shown in the following figure.
Extended Field Relationship with Defined Subscripted Relationship
COMMAND ===> SCROLL ===> CSR
Primary Command: CONDitional relationships, SUGgest Relationships
Line Commands: Field Number to Define Relationship D = Delete Relationship
Parent: MVS-TSOID01.FASAMP.INVFILE
Dependent: MVS-TSOID01.FASAMP.INVFILE
CMD Parent fields Type(Length) Mapped fields
---- ------------------------------- ------------ -----------------------------
____ 5/INV-WAREHOUSE(1) CHAR(3) 6(1,3,1)/INV-STATUS(1)
- - - - - - - - - End of Related Columns - - - - - - - - -
____ INV-PART-NO CHAR(15)
____ INV-DESCRIPTION CHAR(40)
____ INV-UNIT-OF-MEASURE CHAR(2)
____ INV-UNIT-PRICE DEC(7,2)
____ INV-WAREHOUSE(2) CHAR(3)
NMBR Dependent fields Type(Length)
---- ------------------------------- ------------
1 INV-PART-NO CHAR(15)
2 INV-DESCRIPTION CHAR(40)
3 INV-UNIT-OF-MEASURE CHAR(2)
4 INV-UNIT-PRICE DEC(7,2)
5 INV-WAREHOUSE(2) CHAR(3)
See Relationships for a description of the fields. Note that the element notation for the parent is enclosed in parentheses following the parent field name, while the element notation for the dependent is enclosed in parentheses following the dependent name in the Mapped Fields area.