XML repeating segments - losing segments on output

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
madog
Charter Member
Charter Member
Posts: 16
Joined: Tue Jul 11, 2006 10:50 pm
Location: Melbourne

XML repeating segments - losing segments on output

Post by madog »

My XML input looks like below - with E1BPMEPOTEXTHEADER repeating, but one of them will have a different TEXT_ID value and different TEXT_LINE value.

Code: Select all

  <E1BPMEPOTEXTHEADER>
    <PO_NUMBER>ABCDEFG</PO_NUMBER>
    <TEXT_ID>F12</TEXT_ID>
	  <NEW_ELEMENT></NEW_ELEMENT>
    <TEXT_LINE>37806884</TEXT_LINE>
  </E1BPMEPOTEXTHEADER>
  <E1BPMEPOTEXTHEADER>
    <PO_NUMBER>ABCDEFG</PO_NUMBER>
    <TEXT_ID>F10</TEXT_ID>
    <TEXT_LINE>Q00000224</TEXT_LINE>
  </E1BPMEPOTEXTHEADER>
On my output, I keep losing one of them.. and I only end up with the second block:

Code: Select all

  <E1BPMEPOTEXTHEADER>
    <PO_NUMBER>TQ00000224</PO_NUMBER>
    <TEXT_ID>F10</TEXT_ID>
    <TEXT_LINE>TLSTQ00000224</TEXT_LINE>
  </E1BPMEPOTEXTHEADER>
In my definition of the XML file - I have the E1BPMEPOTEXTHEADER set as the key.. and have the 'repetition element required' ticked.

Waht is happening here - how can I stop losing the first segment? help pls.
Post Reply