Sequential File reads decimal field value of Zero as NULL

kamesh · Post by **kamesh** » Mon Dec 13, 2010 4:55 am

Hi,
This might be very stupid question but I am unable to figure why sequential file is reading a decimal filed value of zero as null. This is causing issues in my development logic. Please guide!

ray.wurlod · Post by **ray.wurlod** » Mon Dec 13, 2010 2:44 pm

"All zeroes" is technically not a valid value for a decimal. There is a setting that allows DataStage to treat it as such, but I can't recall what it is at the moment. Hopefully someone else will contribute that before I get to check.