0 Replies Latest reply on May 2, 2014 8:19 PM by user8461308

    How to add extra note between <ROWSET> and <ROW>

    user8461308

      Hello All,

       

      Is there a way to add extra NODE between <ROWSET> and <ROW> that appears ONCE per each XML document

       

      <?xml version="1.0"?>

      <ROWSET>

      <ROW>

        <EMPNO>7369</EMPNO>

        <ENAME>SMITH</ENAME>

        <JOB>CLERK</JOB>

        <MGR>7902</MGR>

        <HIREDATE>17-DEC-80</HIREDATE>

        <SAL>800</SAL>

        <DEPTNO>20</DEPTNO>

      </ROW>

      <ROW>

        <EMPNO>7499</EMPNO>

        <ENAME>ALLEN</ENAME>

        <JOB>SALESMAN</JOB>

        <MGR>7698</MGR>

        <HIREDATE>20-FEB-81</HIREDATE>

        <SAL>1600</SAL>

        <COMM>300</COMM>

        <DEPTNO>30</DEPTNO>

      </ROW>

      ...

      </ROWSET>

       

       

      would be

       

      <?xml version="1.0"?>

      <ROWSET>

      <test>new</test>

      <ROW>

        <EMPNO>7369</EMPNO>

        <ENAME>SMITH</ENAME>

        <JOB>CLERK</JOB>

        <MGR>7902</MGR>

        <HIREDATE>17-DEC-80</HIREDATE>

        <SAL>800</SAL>

        <DEPTNO>20</DEPTNO>

      </ROW>

      <ROW>

        <EMPNO>7499</EMPNO>

        <ENAME>ALLEN</ENAME>

        <JOB>SALESMAN</JOB>

        <MGR>7698</MGR>

        <HIREDATE>20-FEB-81</HIREDATE>

        <SAL>1600</SAL>

        <COMM>300</COMM>

        <DEPTNO>30</DEPTNO>

      </ROW>

      ...

      </ROWSET>

       

      Thank you in advance,  Sonya