I have a requirement wherein, the DB2 tables have to be loaded from the flat files produced from the IMS databases.
The amounts field has PIC as its datatype. There are a few negative amounts as well. In order to load them in a DB2 table, I have used DECIMAL and DECIMAL EXTERNAL data types. But, I am getting the below errors.
112 08:45:27.49 DSNURCON - RECORD (2) WILL BE DISCARDED DUE TO 'IMPOTOT'
CONVERSION ERROR FOR DB2TIVA.IVA_TEST
ERROR CODE '02 - INPUT NUMERIC INVALID'
Would you suggest me the correct DB2 datatype for the amounts fields in PIC, so that they can be loaded successfully in the DB2 table ?