Removing & from the output of an XML
Moderators: chulett, rschirm, roy
Removing & from the output of an XML
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?
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 & to & before feeding the 3rd part application because I do not think you can supress that in DataStage
I suggested that if it is a problem that they would have to write something upfront to convert the & to & before feeding the 3rd part application because I do not think you can supress that in DataStage
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.
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Which stage has XML 'Data Type'?
[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!
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!
Alex