You can edit the record layout of a DB2 table in a DB2 data map.
For example, you can edit a field in a record that contains three items to separate the data in the field into child fields.
In this example, the MISC_DATA field is defined as a CHAR(15) field. However, the field is used to store three Packed decimal fields, each with a precision of 9 and scale of 2.
To edit the record layout in a DB2 data map:
Open the data map.
Open the record.
In the
Record
window, right-click the MISC_DATA field and click
Properties
.
The
Field Properties
dialog box appears.
At
Field Type
, enter
GROUP
.
Click
OK
.
In the
Record
window, right-click the MISC_DATA field and click
Add Field as Child
.
Add the MISC_1, MISC_2, and MISC_3 fields as children of the MISC_DATA field. Define each field as a PACKED field with a precision of 9 and a scale of 2.