title: Recursive query in DB2 to get all items in the chain
body: <p>I have to retrieve all clients linked via loans by giving only one as input. Example I have a table data as</p>
  
  <p>TABLEA</p>
  
  <pre><code>LOAN_ID    CLIENT_ID
  1          7
  1          8
  2          7
  4          8
  4          9
  4         10
  5          9
  5         11
  13        2
  14        3
  </code></pre>
  
  <p>If I have given only input as CLIENT_ID=7 then the query has to select all the columns from above table except last two column because client_id 7 has 1,2 LOAN_ID and in 1 the CLIENT_ID 8 has loan_id=4 and in this loan CLIENT_id 9 has again 5 as loan_id.</p>
  
  <p>can we write a sql query for this without stored procedure in DB2 ?</p>