Empty String in Hash File

yiminghu · Post by **yiminghu** » Wed May 19, 2004 4:36 pm

Hi,

I have a problem. When I used hash file as source to insert rows into DB2 table. If there is empty string, it will insert a very weird character in DB2 instead of leaving it as empty string.

Has anyone encoutered such problem before? What's the solution ?

Thanks,

Yiming

ray.wurlod · Post by **ray.wurlod** » Wed May 19, 2004 8:11 pm

It may not be an empty string; it may be a NULL. You'll have to look at the job that loads the hashed file to determine this. Remember that the default behaviour of a sequential file stage is to convert "" to NULL; you override this default on the Format tab on its Outputs tab.
The representation of NULL and the representation of the Euro character may overlap on the client (Windows uses Char(128) to represent the Euro character), so what you're seeing in the data browser may be affected by that.

yiminghu · Post by **yiminghu** » Thu May 20, 2004 8:13 am

Hi Ray,

It worked. Thanks a lot.

Yiming