title: DB2: Function to merge 3 column output
body: <p>I have below records in table1 </p>
  
  <pre><code>c1  c2  c3
  ----------
  A   B   C
  </code></pre>
  
  <p>How to merge c1 c2 and c3 so the output would like </p>
  
  <p>A B C 
  with space in between the output 
  I used concat function but its not taking 3 arguments 
  like </p>
  
  <pre><code>select concat (c1,c2,c3) from table1
  </code></pre>
  
  <p>I cant run <code>select * from table1</code> as I want output in one column </p>