title: Informix SQL error - Why won't this UPDATE statement work?
body: <p>Using IBM Informix Dynamic Server Version 10.00.FC9</p>
  
  <p>The error I'm getting is:</p>
  
  <p><code>1226: Decimal or money value exceeds maximum precision.</code></p>
  
  <p>Normally, this makes perfect sense and I can fix the precision via <code>CAST</code>, but everything I try is still producing the same error.</p>
  
  <p>I have three columns that I initially set to a constant of <code>0.00</code>.  After a few statements, I have updated two of these columns to positive decimals keeping the same precision.</p>
  
  <p>When I try to multiply these two columns together to update the third column, I get the error above.</p>
  
  <p>My update statement is: <code>UPDATE table SET col_3 = col_1*col_2;</code>
  <hr>
  I've tried several things, but have had no luck in avoiding that error.</p>
  
  <p>I tried setting the constant in <code>col_3</code> to <code>0.000000</code>.  </p>
  
  <p>I also tried updating using <code>CAST</code> on both the two sides of the multiplication and the final value:</p>
  
  <p><code>UPDATE table  SET col_3 = CAST((col_1) AS DECIMAL(6,2))*CAST((col_2) AS DECIMAL(6,2));</code></p>
  
  <p><code>UPDATE table SET col_3 = CAST((col_1*col_2) AS DECIMAL(6,2));</code></p>
  
  <p>Any combination of these attempts always results in the same error.</p>
  
  <p>Does anyone know what I'm missing here or doing wrong?  </p>