Page 1 of 1
Posted: Mon Sep 26, 2016 8:39 am
by eostic
Whatever tool is writing your xml from Netezza needs to escape it. It should be <. If it isn't, that's the problem.
Ernie
Posted: Tue Sep 27, 2016 5:17 am
by 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
Posted: Wed Sep 28, 2016 10:40 am
by 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