title: DB2 Select Query with data in file
body: <p>Lets say I have a csv file(ids.csv) with ids like</p>
  
  <pre><code>101,102,103......1MILLION
  </code></pre>
  
  <p>I wanted to select data from the table by reading ids from file in the where clause</p>
  
  <p>Something like</p>
  
  <pre><code>select * from employee where id in (&lt;I wanted to read ids from external csv file&gt;)
  </code></pre>
  
  <p>Is this possible in any database. I am interested in db2.</p>
  
  <p>Due to limitation in character length in sql if i put all these ids in in clause its not allowing to run a query. Right now I am chunking ids in to smaller set and running the query.</p>