Hi,
When I prepared job in the output under column Instead of empty it showing "0"value, but i didn't given any integer value for the row but it showing "0", can any one share their experiance how to solve this problem
The output value storing in Sequencial file
Instead of "0" want to show empty result
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You have declared the data type to be Integer. "" is not a valid Integer.
Change the data type to VarChar or send NULL instead of 0 and set the Null Field Value property to "".
Change the data type to VarChar or send NULL instead of 0 and set the Null Field Value property to "".
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom