Have WMQI 2.1 , and need to understand the most efficient way to code this in ESQL. Here's a simple example of the source... and what the target needs to look like ( see below ).
 
Not sure if this is easily accomplished with (1) "select" commands, or (2)  a cursor approach. i.e. Creating a reference then Moving to the reference... FirstChild, Next Sibling... or (3) Getting the Cardinality at a particular reference... then looping through setting Input to an Output.  Really a matter of getting the groupN tags out of the way.... moving their children up a level to a new parent group.
 
Anyone done something similar.... or have thoughts on it?  TIA   
 
jesse goode jr
valero energy corp.
 
 
<source>
    <topGroup>
        <group1>
            <aData1>
            <aData2>
            <aData3>
        </group1>
        <group2>
           <bData1>
            <bData2>
            <bData3>
        </group2>
       <groupN>
            <cData1>
           <cData2>
            <cData3>
        </groupN>
    </topGroup>
</source>
 
 
<target>
    <myNewGroup>
          <aData1>
          <aData2>
          <aData3>
          <bData1>
          <bData2>
          <bData3>
          <cData1>
          <cData2>
          <cData3>
    <myNewGroup>
<target>

Reply via email to