counting number of records in the XML file at XML side

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
thamark
Premium Member
Premium Member
Posts: 43
Joined: Thu Jan 29, 2004 12:12 am
Location: US

counting number of records in the XML file at XML side

Post by thamark »

I have Database to XML generation job.
I need to do the reconcillation of the same, how could i able to achive this.
counting number of records in the XML file at XML side in DataStage.

example.

<Main Tag>
<Total Tag>
<SubTag1Total>7</SubTag1Total>
<SubTag2otal>7</SubTag1Total>
<SubTag3otal>7</SubTag1Total>
</Total Tag>
<SubTag>
Data of Record1
Data of Record2
Data of Record3
Data of Record4
Data of Record5
Data of Record6
Data of Record7
</SubTag>
<SubTag1>
Data of Record1
Data of Record2
Data of Record3
Data of Record4
Data of Record5
Data of Record6
Data of Record7
</SubTag1>
<SubTag2>
Data of Record1
Data of Record2
Data of Record3
Data of Record4
Data of Record5
Data of Record6
Data of Record7
</SubTag2>
</Main Tag>

I need to achive the <Total Tag> part by using XML Writer stage.
I am looking forward for your response.

Thanks & Regards
Kannan
Post Reply