DSXchange

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

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.

Hi Ray,

It worked. Thanks a lot.

Yiming