title: How can I concatenate character values in a GROUP BY query in DB2?
body: <p>Does someone knows how to get that result bellow ? </p>
  
  <p>There is a sceneario </p>
  
  <pre><code>ID          DATE        Description
  00041454707 27/07/17    Hospital Sugisawa Pronto Atendimento
  00041454707 27/07/17    Hospital Pequeno Príncipe
  00041454707 28/07/17    Hospital Sugisawa Pronto Atendimento
  </code></pre>
  
  <p>Result expected : </p>
  
  <pre><code>ID          DATE        Description
  00041454707 27/07/17    Hospital Sugisawa Pronto Atendimento | Hospital Pequeno Príncipe
  00041454707 28/07/17    Hospital Sugisawa Pronto Atendimento
  </code></pre>
  
  <p>Look at result ,I've grouped the first and second one , which has same date 
   <strong>27/07/17</strong> , and concatened in Description field . </p>
  
  <p>I dunno have much background in DB2 . </p>
  
  <p>DB2 V11.1</p>