XML Parsing Query - Special Characters

[eostic]

Whatever tool is writing your xml from Netezza needs to escape it. It should be &lt. If it isn't, that's the problem.

Ernie

[eostic]

First thing to do is to be sure and check the string in your .xml from Oracle and see what the character value "really" is. Is it >> or is it an escaped edition --- meaning: Don't look at it in your browser or other xml aware tool....look at the xml in a text editor, and preferably, something that can view the data in hex so that you can be certain.

Then....review the tooling (is it DataStage?) that is responsible for "when same CLOB field goes to Netezza". What is "it" doing?

Ernie

[SachinCho]

Hi Ernie,
This is how string it looks in notepad++


Oracle database it looks like as below


If I convert the string to hex in text editor it looks like


Yes it is moving from Oracle to Netezza via Datastage. So will check how it is getting transformed to below string in Netezza


Thanks,
Sachin