title: Create a delimitted string from a query in DB2
body: <p>I am trying to create a delimitted string from the results of a query in DB2 on the iSeries (AS/400). I've done this in T-SQL, but can't find a way to do it here.</p>
  
  <p>Here is my code in T-SQL. I'm looking for an equivelant in DB2.</p>
  
  <pre><code>DECLARE @a VARCHAR(1000)
  SELECT @a = COALESCE(@a + ', ' + [Description], [Description])
  FROM AP.Checkbooks
  SELECT @a
  </code></pre>
  
  <p>If the descriptions in my table look like this:</p>
  
  <blockquote>
    <p>Desc 1<br>
    Desc 2<br>
    Desc 3</p>
  </blockquote>
  
  <p>Then it will return this:</p>
  
  <blockquote>
    <p>Desc 1, Desc 2, Desc 3</p>
  </blockquote>