title: DB2 Error SQLERRMC:DECFLOAT... sometimes
body: <p>This one really has me scratching my head. This statement:</p>
  
  <pre><code>SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT = 30
  </code></pre>
  
  <p>works just fine, but this one:</p>
  
  <pre><code>SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT = 20
  </code></pre>
  
  <p>Gives me the</p>
  
  <pre><code>DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECFLOAT, DRIVER=3.57.82
  </code></pre>
  
  <p>error message, which I understand indicates that the value for PERCENT is malformed. PERCENT has a type of DECIMAL. Anyone have any ideas? 10 also fails, but all numbers above 30 work fine.</p>
  
  <p>Even better, </p>
  
  <pre><code>SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT &lt; 31 AND PERCENT &gt; 29 works just fine but
  
  SELECT CODE FROM CODES_TABLE WHERE STATUS = 0 AND PERCENT &lt; 21 AND PERCENT &gt; 19
  </code></pre>
  
  <p>yields the same error</p>