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.

IMS_Views_Table_Columns_with_Scale.JPG

 

  1. Scroll so you can see the both the field row containing the packed decimal data and the scale attribute column.

  2. In Scale enter the number of decimal places the field contains. The PRICE field contains two decimal places so the Scale value has been changed to 2.

IMS_Views_Table_Columns_with_new_Scale.JPG

  1. Save your changes.