hi
while i am loading the data in to target i am getting this is follwing error
CIDocData operator=(char): String too long for field .
and my input column type is varchar and output olumn type is char
CIDocData operator=(char): String too long for field .
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 70
- Joined: Thu Nov 09, 2006 2:14 am
Shrinivas,
please post in the appropriate forum - either Server or PX for this question (although it does look like PX).
What is your problem with the error? If you have a column defined as char(16) and try to put the varchar text "Hello World, my name is Arnd" into it you will get this error message.
please post in the appropriate forum - either Server or PX for this question (although it does look like PX).
What is your problem with the error? If you have a column defined as char(16) and try to put the varchar text "Hello World, my name is Arnd" into it you will get this error message.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your problem is that your data do not conform to your metadata. One (at least) of your rows contains a value in the VarChar field that is too large to fit into the Char field. Use a substring function to effect the appropriate truncation. Or delcare the Char field large enough. I presume from the function name that this is being accessed from an IDoc.
Last edited by ray.wurlod on Tue Jan 09, 2007 4:15 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.