title: SQLCODE: -420, SQLSTATE: 22018, SQLERRMC: BIGINT
body: <p>[Running DB2 UDB version 9] Why does this SQL statement work</p>
  
  <pre><code>SELECT 
         CASE
         WHEN A.DAILYDOWNLOADSIZE is null THEN 0
      else bigint(A.DAILYDOWNLOADSIZE)
         END "DAILYDOWNLOADSIZE",
         CASE
         WHEN A.DAILYDOWNLOADTIME is null THEN 0
      else bigint(A.DAILYDOWNLOADTIME)
         END "DAILYDOWNLOADTIME"
  FROM 
  EDMPROD.MQT_STB_FACTS A 
  </code></pre>
  
  <p>...when this one does not</p>
  
  <pre><code>SELECT DISTINCT 
  bigint(A.CAMID) AS "CAMID",
  bigint(A.RID) AS "RID",
  A.SOFTWAREVERSION,
  A.MODELNUMBER,
  A.MANUFACTURERID,
  A.MODDATE,
  A.POSTTIME,
  A.DELIVERYMETHOD,
  bigint(A.UPTIME )  AS "UPTIME",
  bigint(A.NUMBEROFRESETSSINCELASTSWDL )  AS "NUMBEROFRESETSSINCELASTSWDL",
  bigint(A.NUMBEROFSEARCHSIGNALOSDTUNER1 ) AS "NUMBEROFSEARCHSIGNALOSDTUNER1",
  bigint(A.NUMBEROFSEARCHSIGNALOSDTUNER2 ) AS "NUMBEROFSEARCHSIGNALOSDTUNER2",
  bigint(A.NUMBEROFUSERDISKREFORMATS ) AS "NUMBEROFUSERDISKREFORMATS",
  bigint(A.NUMBEROFSYSTEMDISKREFORMATS ) AS "NUMBEROFSYSTEMDISKREFORMATS",
  bigint(A.NUMBEROFRECOVEREDDISKERRORS ) AS "NUMBEROFRECOVEREDDISKERRORS",
  IPINFO,
         CASE
         WHEN A.DAILYDOWNLOADSIZE is null THEN 0
      else bigint(A.DAILYDOWNLOADSIZE)
         END "DAILYDOWNLOADSIZE",
         CASE
         WHEN A.DAILYDOWNLOADTIME is null THEN 0
      else bigint(A.DAILYDOWNLOADTIME)
         END "DAILYDOWNLOADTIME",
  bigint(A.TOTALNUMBEROFDOWNLOADSSTARTED ) AS "TOTALNUMBEROFDOWNLOADSSTARTED",
  bigint(A.TOTALNUMOFCOMPLETEDDLS ) AS "TOTALNUMOFCOMPLETEDDLS",
  CURRENT_DATE AS "LOAD_DATE"
  FROM 
  EDMPROD.MQT_STB_FACTS A 
  </code></pre>
  
  <p>I get an error <strong>SQL0420N  Invalid character found in a character string argument of the 
  function "BIGINT".  SQLSTATE=22018</strong>. </p>
  
  <p>By troubleshooting the query, I confirm the culprits are the two columns DAILYDOWNLOADSIZE and DAILYDOWNLOADTIME. Both must be casted from character(15) to bigint.</p>
  
  <p>What is the second SQL statement not working???</p>