Page 1 of 1

counting number of records in the XML file at XML side

Posted: Mon Feb 02, 2004 3:06 am
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