Sequential Files : Null values are converted to symbol â‚¬

Sreenivasulu · Post by **Sreenivasulu** » Wed Aug 05, 2009 1:19 am

Not heard of this change from windows. This change also does not look logical. Pls verify one more time

Regards
Sreeni

ray.wurlod · Post by **ray.wurlod** » Wed Aug 05, 2009 1:49 am

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).

pascalnicolasl · Post by **pascalnicolasl** » Wed Aug 05, 2009 5:21 am

Thanks ray.wurlod

If anyone has a workaround to solve this bug, please let me know

chulett · Post by **chulett** » Wed Aug 05, 2009 5:25 am

Are you reading from or writing to the sequential file when you have this problem?

pascalnicolasl · Post by **pascalnicolasl** » Wed Aug 05, 2009 1:23 pm

Hello

I am writing data in a sequential file.

Thanks in advance,
Nick

chulett · Post by **chulett** » Wed Aug 05, 2009 2:13 pm

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?

ray.wurlod · Post by **ray.wurlod** » Thu Aug 06, 2009 4:27 pm

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>".

SHARAD123 · Post by **SHARAD123** » Thu Aug 06, 2009 9:57 pm

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