title: Export data from db2 with column names
body: <p>I want to export data from db2 tables to csv format.I also need that first row should be all the column names.</p>
  
  <p>I have little success by using the following comand</p>
  
  <pre><code>EXPORT TO "TEST.csv" 
  OF DEL 
  MODIFIED BY NOCHARDEL coldel: ,
  SELECT col1,'COL1',x'0A',col2,'COL2',x'0A' 
  FROM TEST_TABLE;
  </code></pre>
  
  <p>But with this i get data like </p>
  
  <pre><code>Row1 Value:COL1:
  Row1 Value:COL2:
  Row2 Value:COL1:
  Row2 Value:COL2:
  </code></pre>
  
  <p>etc.</p>
  
  <p>I also tried the following query</p>
  
  <pre><code>EXPORT TO "TEST.csv" 
  OF DEL 
  MODIFIED BY NOCHARDEL 
  SELECT 'COL1',col1,'COL2',col2 
  FROM ADMIN_EXPORT;
  </code></pre>
  
  <p>But this lists column name with each row data when opened with excel.</p>
  
  <p>Is there a way i can get data in the format below</p>
  
  <pre><code>COL1   COL2
  value  value
  value  value
  </code></pre>
  
  <p>when opened in excel.</p>
  
  <p>Thanks</p>