XML Write Header and Footer - CData
Posted: Sun Apr 14, 2019 6:37 pm
Hi All,
I'm trying to write an XML using DS and ive managed to create all the repeated elements using key and trigger columns;Special thanks to Ernie on his posts about xml. Now i need to add header and footer outside of the element tag and these should have free form text that is of CDATA. (ex: <Header>
<![CDATA[ message ]]>
</Header>
I've found a post that tells me use hash files and a lookup to use, however as I'm using 11.5 is there an alternative to this?
Also, how do we get this free form text tag <![CDATA[ message ]] using Datastage xsd. I've changed the datatype to char and dataelement type as xml but not able to achieve this
For every column description, my fields have /root/<elementtagname>/<columnname>/text() -- So, for achieving CDATA , is there any specific datatype that I need to use or somefeature that I'm missing
Thanks in advance
kaasko
I'm trying to write an XML using DS and ive managed to create all the repeated elements using key and trigger columns;Special thanks to Ernie on his posts about xml. Now i need to add header and footer outside of the element tag and these should have free form text that is of CDATA. (ex: <Header>
<![CDATA[ message ]]>
</Header>
I've found a post that tells me use hash files and a lookup to use, however as I'm using 11.5 is there an alternative to this?
Also, how do we get this free form text tag <![CDATA[ message ]] using Datastage xsd. I've changed the datatype to char and dataelement type as xml but not able to achieve this
For every column description, my fields have /root/<elementtagname>/<columnname>/text() -- So, for achieving CDATA , is there any specific datatype that I need to use or somefeature that I'm missing
Thanks in advance
kaasko