Null Warning.

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
kollurianu
Premium Member
Premium Member
Posts: 614
Joined: Fri Feb 06, 2004 3:59 pm

Null Warning.

Post by kollurianu »

Hi All ,

what does the following warning mean?

APT_CombinedOperatorController(5),0: Field 'Ref_Mainframe_Time_Stamp' from input dataset '0' is NULL. Record dropped.

Thank you all , appreciate your inputs.
kris007
Charter Member
Charter Member
Posts: 1102
Joined: Tue Jan 24, 2006 5:38 pm
Location: Riverside, RI

Post by kris007 »

Are you doing any transformation on the field Ref_Mainframe_Time_Stamp. If so, are you handling NULL's explicitly? If not, you need to do so to avoid dropping records.

Usually, within the transformer stage, Null handling should be done for all nullable fields.
Kris

Where's the "Any" key?-Homer Simpson
kollurianu
Premium Member
Premium Member
Posts: 614
Joined: Fri Feb 06, 2004 3:59 pm

Post by kollurianu »

kris007 wrote:Are you doing any transformation on the field Ref_Mainframe_Time_Stamp. If so, are you handling NULL's explicitly? If not, you need to do so to avoid dropping records.

Usually, within the transformer stage, Null handling should be done for all nullable fields.
Thanks Kris for your response , Yes you are right , now I handled the nulls explicitly.
Post Reply