Page 1 of 1

Sequential File reads decimal field value of Zero as NULL

Posted: Mon Dec 13, 2010 4:55 am
by kamesh
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!

Posted: Mon Dec 13, 2010 2:44 pm
by ray.wurlod
"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.