Extended column relationship definition

The following figure is displayed when you attempt to map two columns/fields containing character (CHAR or VCHAR) or graphic (GRPH or VGRPH) data, or one column/field containing DECIMAL or FIXPIC and its parent or dependent CHAR data.

Extended Column Relationship Definition Window

Use this window to create partial-column/field relationships.

If the columns you want to map are the same length, the fields in this window are prefilled and the following message is displayed:

Complete this window and press Enter to proceed.

The left side of the body of this window contains fields that pertain to the parent column/field:

Number

Displays the number of the parent column/field.

Name

Displays the name of the parent column/field.

Type(Length)

Displays the type of data contained in the parent column/field. The length, in parentheses, follows the data type. If an MVS field includes an occurrence of subscripts, the ARRAY SIZE and MAX LENGTH values are also displayed, see Extended Field Relationship Definition with Field Subscripts Defined for an example.

Start Position

Specify the starting position of the string in the parent column/field that will comprise the column/field relationship.

For DECIMAL columns/fields the Start Position value cannot be changed.

Length

Specify the length of the string contained in the parent column/field on which the column/field relationship will be based.

For DECIMAL data types the Length value represents its internal byte length and cannot be changed.

The right side of the body of this window contains fields that pertain to the dependent column/field:

Number

Displays the number of the dependent column/field.

Name

Displays the name of the dependent column/field.

Type(Length)

Displays the type of data contained in the dependent column/field. The length, in parentheses, follows the data type. If an MVS field includes an occurrence of subscripts, the ARRAY SIZE and MAX LENGTH values are also displayed, see Extended Field Relationship Definition with Field Subscripts Defined for an example.

Start Position

Specify the starting position of the string in the dependent column/field that will comprise the column/field relationship. If the right side does not display a Length field, the length of the dependent column/field is determined by the length of the string in the corresponding parent column/field.

For DECIMAL columns the Start Position value cannot be changed.

Length

(displays only for DECIMAL to CHAR relationships) Specify the length of the converted decimal string in the dependent character column/field. The maximum length of a DECIMAL to CHAR conversion is “precision + sign + decimal delimiter”. For example, maximum CHAR length for DEC(9,2) is 11 (9 + 1 + 1).

This section provides information about the following topics: