warning for null field

samsuf2002 · Post by **samsuf2002** » Thu Oct 05, 2006 3:13 pm

hi i am runnung a parallel job with two seq files input to CDC and out put to a seq file

job is running fine but i am getting this warnings

When checking operator: When validating export schema: At field "lat": "null_field" length (0) must match field's fixed width (9)

these warnings are for 2 fields which are decimal 7,4

Can any one plz help out here
Thanks

kris007 · Post by **kris007** » Thu Oct 05, 2006 3:30 pm

You already have a post running on this topic and a post resloved on this topic. I don't think advice would be any different from what Arnd has suggested in other post i.e. Search.

What you are trying to do is read data from fixed-width files and have not defined on how to handle any null values. Try the suggestions in the above link. You might get lucky

ambasta · Post by **ambasta** » Fri Oct 06, 2006 6:56 am

Try NULL FIELD VALUE=' ' in sequential file.

samsuf2002 · Post by **samsuf2002** » Fri Oct 06, 2006 8:08 am

i tried Null Field value = ' ' but still it is giving this warning .My file is a pipe delimited why it is giving warning as fixed width i dont knw.

ambasta · Post by **ambasta** » Fri Oct 06, 2006 10:38 am

if there are only two column u can do edit at column level.can u go to that column and place those many no of spaces as ur field length.try this and let us know.

samsuf2002 · Post by **samsuf2002** » Thu Oct 19, 2006 8:52 am

Can any body please suggest some more
Thanks

kumar_s · Post by **kumar_s** » Fri Oct 20, 2006 2:01 am

If the column is decimal, give the default value equal in digit to the given spec. Like
Null Field Value - '000.0000'
Also check the stage on which the warning is appearing.