DSXchange

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

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

Try NULL FIELD VALUE=' ' in sequential file.

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.

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.

Can any body please suggest some more
Thanks

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.