Records are rejected which have Null Values for ints & D

hari_marthala · Post by **hari_marthala** » Mon Jun 04, 2012 7:46 am

Hi,

Can anybody help me in resolving my issue which is mentioned below,

Issue:- My source is sequential file with integer and date fields as nullable, but the records are getting rejected as it contains NULL values from source even though i had given "Null Field Value" as blank('' ie; just single quotes one after another).

Is there any other option to read null values in integer and date fields which are nullable from source

rjdickson · Post by **rjdickson** » Mon Jun 04, 2012 1:46 pm

'' (an empty string) is neither a valid numeric, nor a valid date. Try setting the 'null field value' to something valid for each column (i.e. set the integer column default value to 0, etc).

ray.wurlod · Post by **ray.wurlod** » Mon Jun 04, 2012 1:56 pm

What does the source actually put into those fields to represent NULL? That's what you must have as the Null Field Value property.

If they are actually empty, try using double quotes rather than single quotes for Null Field Value.

If you have a fixed-width format, however, you need the Null Field Value to have the same number of characters (probably all space characters) as the field in question.