Data not able to load into unicode field

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
BradMiller
Premium Member
Premium Member
Posts: 87
Joined: Mon Feb 18, 2008 3:58 pm
Location: Sacramento, CA

Data not able to load into unicode field

Post by BradMiller »

I am trying to load the data "XO" into a sap idoc segment field whose datatype is varchar(2) but its failing with the following error message.
"IDoc_Load_ZAFSMATMAS01,0: Fatal Error: Fatal: IDOC_F_00145`:`Segment 'Z2BP_MARCX000', Field 'MRP_TYPE', Value 'ND': CIDocData operator=(char): String too long for field"

I am not able to understand if the value is "XO" why is it not able to load into char(2) could you anyone suggest me.
BradMiller
Premium Member
Premium Member
Posts: 87
Joined: Mon Feb 18, 2008 3:58 pm
Location: Sacramento, CA

Post by BradMiller »

I got the answer by myself usually for unicode the length has to be double.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Bytes, not characters. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply