title: how to pass multi-valued parameter in where clause in db2?
body: <p>I have two parameters in a report</p>
  
  <p>1.Location</p>
  
  <p>2.Id</p>
  
  <p>{Location} takes just a single value, where as {Id} takes multiple values</p>
  
  <p>When i write the following query</p>
  
  <pre><code>Select Emp_Name, Salary, Manager from Employee_Details
  where Emp_Location = {Location}
  </code></pre>
  
  <p>It works absolutely fine.</p>
  
  <p>but when i pass the parameter with multiple values in where clause, the code gives error.</p>
  
  <pre><code>Select Emp_Name, Salary, Manager from Employee_Details
  where Emp_ID in {ID}
  </code></pre>
  
  <p>How to pass a parameter with multiple values in the where clause?</p>