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
Empty String in Hash File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.