Page 1 of 1

Sequential file warnings

Posted: Thu Sep 28, 2006 9:53 am
by samsuf2002
Hi All
i am running a parallel job on windows with two input seq files , transformer and out put seq file i am getting a bunch of warnings as:

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

there are around 150 fields just want to know how to avoid this warnings are they harmful.

thanks in advance

Posted: Thu Sep 28, 2006 10:16 am
by kris007
Tell us more about your input seq files. Are they fixed width? If yes, what did you set the Null field length to in the format tab. You might also need to use an environment variable such as "APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL"

Posted: Thu Sep 28, 2006 10:46 am
by samsuf2002
i got the solution my file is a pipe delimited and i was using unicode for some fields when i removed unicode all the warnings were cleared.

Thanks any way