Warning on a decimal field

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
vij
Participant
Posts: 131
Joined: Fri Nov 17, 2006 12:43 am

Warning on a decimal field

Post by vij »

hi all,

i get the following warning and the record is also dropped... i would want to know how to avoid this...

APT_CombinedOperatorController,1: Field 'INP_TMP_4' from input dataset '0' is NULL. Record dropped.

This field is a decimal field of length 7 n precision 2

Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Handle situations where the input can be null. Thats what it is complaining.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply