Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    11

    Unanswered: Informix Error -1226 :Decimal or money value exceeds maximum precision.

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •