Page 1 of 1
Posted: Wed Aug 05, 2009 1:19 am
by Sreenivasulu
Not heard of this change from windows. This change also does not look logical. Pls verify one more time
Regards
Sreeni
Posted: Wed Aug 05, 2009 1:49 am
by ray.wurlod
DataStage represents null internally using a single byte with bit pattern 1000000 (or Char(128)). Windows uses this byte to represent the Euro symbol.
I believe there's a way to change the DataStage internal representation, but can't recall what it is (and am not currently working on a Windows server).
Posted: Wed Aug 05, 2009 5:21 am
by pascalnicolasl
Thanks ray.wurlod
If anyone has a workaround to solve this bug, please let me know
Posted: Wed Aug 05, 2009 5:25 am
by chulett
Are you reading from or writing to the sequential file when you have this problem?
Posted: Wed Aug 05, 2009 1:23 pm
by pascalnicolasl
Hello
I am writing data in a sequential file.
Thanks in advance,
Nick
Posted: Wed Aug 05, 2009 2:13 pm
by chulett
Can't you simply avoid sending an actual NULL to any fields? For example, make sure they are explicitly set to an empty string -
"" - instead? Or is there more to the problem?
Posted: Thu Aug 06, 2009 4:27 pm
by ray.wurlod
For text files, change the representation of NULL (either at the file level or at the individual column level) from "" to something else, perhaps "<NULL>".
Posted: Thu Aug 06, 2009 9:57 pm
by SHARAD123
Hi,
I am not sure whether this will work out. Try converting the column using Iconv(col_name,"MCP"). This converts the non readable characters to "." a period.
EReplace to remove the "." period.
Regards,
Sharad