title: How change the XPATH and XML output format in DataStage?
body: <p>I HAVE some problem in XPATH In XML Output</p>
  
  <p>I Want The Output Like </p>
  
  <pre><code>&lt;categories&gt;
    &lt;category NAME="A"&gt;
      &lt;redcord a="1"&gt;&lt;/redcord&gt;
      &lt;redcord a="2"&gt;&lt;/redcord&gt;
    &lt;/category&gt;
    &lt;category NAME="B"&gt;
      &lt;redcord b="ASD"&gt;&lt;/redcord&gt;
      &lt;redcord b="QWE"&gt;&lt;/redcord&gt;
    &lt;/category&gt;
  &lt;/categories&gt;
  </code></pre>
  
  <p>I HAVE XPATH LIKE :</p>
  
  <pre><code>/categories/category[@NAME="A"]/redcord/@a
  </code></pre>
  
  <p>AND </p>
  
  <pre><code>/categories/category[@NAME="B"]/redcord/@b
  </code></pre>
  
  <p>The Output that i've been making is </p>
  
  <pre><code>&lt;categories&gt;
    &lt;category NAME="A"&gt;
      &lt;redcord a="1" b="ASD"&gt;&lt;/redcord&gt;
      &lt;redcord a="2" b="QWE"&gt;&lt;/redcord&gt;
    &lt;/category&gt;
  &lt;/categories&gt;
  </code></pre>
  
  <p>Anyone have any idea how to make the XML format as i wanted above?
  Fyi : I'm using Oracle Database , Datastage</p>