Specifying IMS Packed Decimal Data Fields
When you import IMS files, tables containing packed decimal fields do not contain the decimal point location information. If the packed decimal fields in your IMS tables contain non-integer values, specify the location of the decimal point using the CONNX Data Dictionary Manager.
To specify the decimal point location in the packed decimal field:
1. In the CONNX Data Dictionary Manager, click the IMS table containing the packed decimal field. Click the Table Columns tab.
2. Scroll so you can see the both the field row containing the packed decimal data and the scale attribute column.
3. In Scale, enter the number of decimal places that the field contains.
For example, if the PRICE field contains two decimal places, set the Scale value to 2.
4. Save your changes.