Sequential file warnings

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Sequential file warnings

Post 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
hi sam here
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post 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"
Kris

Where's the "Any" key?-Homer Simpson
samsuf2002
Premium Member
Premium Member
Posts: 397
Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse

Post 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
hi sam here
Post Reply