Whatever tool is writing your xml from Netezza needs to escape it. It should be <. If it isn't, that's the problem.
Ernie
XML Parsing Query - Special Characters
Moderators: chulett, rschirm, roy
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
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
Then....review the tooling (is it DataStage?) that is responsible for "when same CLOB field goes to Netezza". What is "it" doing?
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>