datastage xml parsing
Posted: Fri Jun 05, 2009 11:34 am
We are trying to parse an xml file into tabular form for database update.
The job looks similar to this:
a sequential file -->xml input --> tranformer stage-->sequential file
The xml source is written below. We are having problems with handling multiple languages in the nested tags(Languages).
<?xml version="1.0" encoding="UTF-8"?>
<OfficeLanguages xmlns:pi="http://was.vsp.com/enetwork_web/xml/">
<OLang>
<TXNID>PI18710258:47199993</TXNID>
<OldTax>204999999</OldTax>
<OldHash>991</OldHash>
<OldSeq>2</OldSeq>
<NewTax>20499999</NewTax>
<NewHash>931</NewHash>
<NewSeq>2</NewSeq>
<Active>A</Active>
<Languages>
<Language>Filipino</Language>
<Language>Spanish</Language>
</Languages></OLang>
</OfficeLanguages>
The input stage is able to read all the tags except the language tags within the Languages tag.
Thank you for your time.
The job looks similar to this:
a sequential file -->xml input --> tranformer stage-->sequential file
The xml source is written below. We are having problems with handling multiple languages in the nested tags(Languages).
<?xml version="1.0" encoding="UTF-8"?>
<OfficeLanguages xmlns:pi="http://was.vsp.com/enetwork_web/xml/">
<OLang>
<TXNID>PI18710258:47199993</TXNID>
<OldTax>204999999</OldTax>
<OldHash>991</OldHash>
<OldSeq>2</OldSeq>
<NewTax>20499999</NewTax>
<NewHash>931</NewHash>
<NewSeq>2</NewSeq>
<Active>A</Active>
<Languages>
<Language>Filipino</Language>
<Language>Spanish</Language>
</Languages></OLang>
</OfficeLanguages>
The input stage is able to read all the tags except the language tags within the Languages tag.
Thank you for your time.