Removing &amp from the output of an XML

ggarze · Post by **ggarze** » Mon Jul 06, 2009 9:16 am

I'm creating an XML from a SFF file and one of the values inside the XML document needs to read something like "&NAME;". When I put this value in the transformer and then view the ouput xml file it reads something like as "&NAME;" Is there any option in the XML output stage to supress this and have it shows as I intended?

chulett · Post by **chulett** » Mon Jul 06, 2009 10:40 am

Are you sure you really want to change this? That is standard XML and will "show as intended" when the XML is processed on the receiving end.

ggarze · Post by **ggarze** » Mon Jul 06, 2009 11:36 am

I thought that was the standard as well. The group that I'm investigating this for said that they have a 3rd party application that the feel will not be able to read this because it's validating the xml against a dtd.

I suggested that if it is a problem that they would have to write something upfront to convert the &amp to & before feeding the 3rd part application because I do not think you can supress that in DataStage

chulett · Post by **chulett** » Mon Jul 06, 2009 2:40 pm

It *is* the standard and any validator worth its salt would complain finding that character in there untranslated... i.e. not 'safe'. Perhaps it's an issue with using a dtd rather than the more standard xsd for this. [shrug]

Depending on your job design, you can set the 'Data Type' for that field to 'XML' in the stage, that will tell DataStage that it is already XML and to just pass it through unmolested.

ggarze · Post by **ggarze** » Mon Jul 06, 2009 3:10 pm

Worked great Craig Thanks!!!

schwaa · Post by **schwaa** » Fri Sep 04, 2009 9:08 pm

[img][quote="chulett"]It *is* the standard and any validator worth its salt would complain finding that character in there untranslated... i.e. not 'safe'. Perhaps it's an issue with using a dtd rather than the more standard xsd for this. [shrug]

Depending on your job design, you can set the 'Data Type' for that field to 'XML' in the stage, that will tell DataStage that it is already XML and to just pass it through unmolested.[/quote][/img]

Which stage has XML 'Data Type'? I use 8.0. I had to reply to this thread as I couldn't find any other postings elsewhere. Thanks!

chulett · Post by **chulett** » Fri Sep 04, 2009 10:18 pm

XML Output.

schwaa · Post by **schwaa** » Sat Sep 05, 2009 9:02 am

[quote="chulett"]XML Output. ...[/quote]

Thanks! I found it under the 'Data Element' field.