Warning in Aggregator stage

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
siva7143
Participant
Posts: 35
Joined: Wed Aug 09, 2006 12:20 am

Warning in Aggregator stage

Post by siva7143 »

Hi ,
in aggregator i am getting an waring
"Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted."

But i have enabled in the "Stage options: Allow Null Output=False"

Still i am getting this waring. Can you pl help me out to solve this
mohdsuf
Participant
Posts: 24
Joined: Mon Jun 18, 2007 3:21 am
Location: India

Post by mohdsuf »

Change the nullability of the column to 'Yes' in the output of Aggregrator stage for which you are getting the warning. Generally this sort of warning comes when the input is nullable and the the same output column is set to not null.
Try this and if you still feel the same problem then provide details like columns of input to aggregator and output columns of aggregrator.
Sufiyan
mcs_dineshm
Participant
Posts: 12
Joined: Sun Sep 23, 2007 12:21 am
Location: chennai

Post by mcs_dineshm »

For the column that's showing warning,set the nullable property in the column tab of the aggregator stage as 'yes' then go to target stage and click the particular column so that the extended properties window will appear and in that set the null field value as ''''. Sure u wont get any such warning again..
dineshm
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

U (a different poster) may not, but will siva7143 ?

Correct spelling of the second person personal pronoun is "you", not "u".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply