Hi All,

I am getting this error when I am doing an ETL from DB2 to Informix.

Informix Error -1226 ecimal or money value exceeds maximum precision.

My source has a column with numeric(1,0).

I created the a column with numeric(1,0) in Informix but I see decimal(1,0) when I look at the datatype, it looks like it is changing numerica(1,0) automatically to decimal(1,0).

When I am loading it to the column it is giving me this error.

------Informix Error -1226 ecimal or money value exceeds maximum precision.


And my source has only one number(1,2,3 etc). But after loading the table it is giving me different numbers(0,0,0).

How do I solve this problem?

Thank you for your help in advance.

Hi,

Please remember that you must save one character for the sign.
Remember too that, data types decimal and money manage float point. But numeric and integer not.

Gustavo.