title: db2 - export into File
body: <p>I'm trying to export the result of a query in db2 to file, but the result like:</p>
  
  <pre><code> +000000869836.|+00000000000001401.
   +000000978137.|+00000000000000511.
  </code></pre>
  
  <p>What can I do to obtain the following result:</p>
  
  <pre><code> 869836.|1401.
   978137.|511.
  </code></pre>
  
  <p>My current query:</p>
  
  <pre><code>EXPORT TO /tmp/tmp.tmp OF del modified by NOCHARDEL coldel|
  select
  iv.bpd_instance_id,
  max(case when alias = 'abc' then INT_VALUE else null end) as A,
  max(case when alias = 'xyz' then STRING_VALUE else null end) as X,
  from lsw_bpd_instance_variables iv
  where bpd_instance_id in ($instancesDB)
  group by iv.bpd_instance_id
  with ur
  </code></pre>