CIDocData operator=(char): String too long for field .

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
uppalapati2003
Participant
Posts: 70
Joined: Thu Nov 09, 2006 2:14 am

CIDocData operator=(char): String too long for field .

Post by uppalapati2003 »

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
Srini
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
uppalapati2003
Participant
Posts: 70
Joined: Thu Nov 09, 2006 2:14 am

Hai

Post by uppalapati2003 »

Hi Ray,
Thanks
Srini
Post Reply