Instead of "0" want to show empty result

deesh · Post by **deesh** » Thu Mar 19, 2009 11:23 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Mar 19, 2009 11:35 pm

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Mar 20, 2009 3:20 am

What is its derivation?