title: Datatype conversion in IBM DB2: BIGINT to VARCHAR
body: <p>I'm writing a query to do some stuff. But its not working the way I want it to:</p>
  
  <pre><code>select CORR_ID from TABLE1
  where CORR_ID not in (select id from TABLE2)
  </code></pre>
  
  <p>The problem is, TABLE2.id is a long, while TABLE1.CORR_ID is a string.</p>
  
  <p>So how can I make it work?</p>
  
  <p>PS: I'm using IBM UDB.</p>