title: IBM DB2 SQLException with "DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECFLOAT, DRIVER=3.66.46"
body: <p>I am working on a Jasper report using iReport 5.6 and IBM DB2 as data source. I am passing a list of strings as a parameter to the report and that is where the problem rises. The query is below; </p>
  
  <pre><code>SELECT customers.mobile_number, 
      COALESCE(Count(DISTINCT transaction_entries.transaction_id), 0) AS 
      number_of_transactions, 
      COALESCE(Sum(Abs(transaction_entries.amount)) / 100, 0)         AS 
      volume_of_transactions 
  FROM   transaction_entries 
      JOIN customers 
        ON customers.id = transaction_entries.customer_id 
  WHERE  transaction_entries.transaction_type = 'Seasonal' 
      AND transaction_entries.notification_text &lt;&gt; 'Notification' 
      AND customers.mobile_number IN ( $p ! {listOfMobileNumbers} ) 
  GROUP  BY customers.mobile_number 
  </code></pre>
  
  <p>When I try to generate the report I get the error Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-420, SQLSTATE=22018, SQLERRMC=DECFLOAT, DRIVER=3.66.46.</p>
  
  <p>Any idea why ? and the possible solution ? </p>