I am using Db2 connector as source, copy stage, Teradata connector as Target stage.
In Teradata connector stage:
Load type : Immediate
Enabled LOB reference.
XML column is defined as LongNVarchar(2097088000) both in source & target stage.
When I load data the xml content is loading as character set.
< is replaced by < , > is replaced by >.
Do we have any steps need to take care in order to load xml content properly. ?
In case there was a question on certain symbols getting replaced, there are 5 invalid XML characters that must be escaped when in the data, in order to have proper XML content. Examples:
The column is defined as XML in both source & target database, but in datastage meta, if we import, it was coming as UNKNOWN -370; So we changed to LongNVarchar(2097088000).
Note that we're not discussing the data type here but rather a property called data element. It's in the documentation and has been discussed in the forums here, for example in this post.
-craig
"You can never have too many knives" -- Logan Nine Fingers
When I choose the Data Element as XML , then it was throwing error as "the data element selected is not compatible with the SQL data type".
So, now the issue is when I edit the xml file in note pad , every thing looks good , but the spaces are stripped , making the xml content as long string.