title: Select on CLOB XML DB2
body: <p>I have this data as <code>CLOB</code> field in DB2. I am converting the data to <code>char</code> using cast: </p>
  
  <pre><code>SELECT CAST(CLOBColumn as VARCHAR(32000))
  FROM Schema.MyTable;
  </code></pre>
  
  <p>Here is how the result XML comes out from the above:     </p>
  
  <pre><code>&lt;TreeList TreeNo="ABC"&gt;
      &lt;Tree ErrorCode="INVALID_TREE" ErrorDescription="Tree doesn’t exist." TreeID="123456"/&gt;
      &lt;Tree ErrorCode="INVALID_TREE" ErrorDescription="Tree doesn’t exist." TreeID="1234567"/&gt;
  &lt;/TreeList&gt;
  </code></pre>
  
  <p>And this is how I expect my output </p>
  
  <pre><code>|TreeNo | TreeID  |   ErrorCode  | ErrorDescription
  |ABC    | 123456  | INVALID_TREE | Tree doesn’t exist
  |ABC    | 1234567 | INVALID_TREE | Tree doesn’t exist
  </code></pre>
  
  <p>How do I achieve this?</p>