title: how can i dynamically pass value to db2 search clause 'like' while fetching result from other table
body: <p>Can someone help me how can i dynamically pass value to db2 search clause <code>like</code> while fetching result from other table.</p>
  
  <p>I am trying this: </p>
  
  <pre><code>select * from table2 where file_name like '%(select file_name from table1)'
  </code></pre>
  
  <p>I've even tried CONTACT, using sysibm.sysdummy1 methods but no luck. </p>