DSXchange

Posted: **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

Posted: **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 "".

Posted: **Fri Mar 20, 2009 3:20 am**

What is its derivation?

DSXchange

Instead of "0" want to show empty result

Instead of "0" want to show empty result