Maximum length while generating an XML
Posted: Mon Aug 02, 2010 2:03 am
We have a requirement in which we are generating an XML with repeating Layout like given below
(e.g):-
-<Claims>
-<Feature>
+<Data1>
+<Data2>
+<Data3>
</Feature>
+<Feature>
+<Feature>
</Claims>
.
Please do note that Data1 is a tag.One Feature can have "N" number of Data1,similarly Data2 and so on.
Now what i am trying to do is .
I am generating all the Feature related Data in a XML and storing it in a
"File Set" in a single column of Data type (LongVarChar)---(99999).
When i try to link this column from the File to generate XML at Claim Level.
The data is getting truncated saying
Error Msg:-
_________
File_Set_132,0: The message's length (81125) exceeds the limit (65467) and it can't be broken at newlines; the message is truncated.
I have defined the length has 99999(Varchar). How to over come this
Is there is any other datatype in Datastage which could be defined with length greater than this.
Please suggest some approach.This is very Important for my project.
Thanks in advance!!!
(e.g):-
-<Claims>
-<Feature>
+<Data1>
+<Data2>
+<Data3>
</Feature>
+<Feature>
+<Feature>
</Claims>
.
Please do note that Data1 is a tag.One Feature can have "N" number of Data1,similarly Data2 and so on.
Now what i am trying to do is .
I am generating all the Feature related Data in a XML and storing it in a
"File Set" in a single column of Data type (LongVarChar)---(99999).
When i try to link this column from the File to generate XML at Claim Level.
The data is getting truncated saying
Error Msg:-
_________
File_Set_132,0: The message's length (81125) exceeds the limit (65467) and it can't be broken at newlines; the message is truncated.
I have defined the length has 99999(Varchar). How to over come this
Is there is any other datatype in Datastage which could be defined with length greater than this.
Please suggest some approach.This is very Important for my project.
Thanks in advance!!!