Getting Warnings for Nullability

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
skp
Premium Member
Premium Member
Posts: 135
Joined: Wed Dec 26, 2007 1:56 am
Location: India

Getting Warnings for Nullability

Post by skp »

Hi Please help me on the below warnings...

my source is DB2 table in that i am extracting columns from different tables based on joins... In that i have 2 columns extracting from one table, in the table the nullability is No and same I am passing to dataset.
Job design is DB2---->Copy----->Dataset
I checked in all stages the nullability is No.
But I am getting the below errors, really i am wonder why i am getting this errors... please help me on this...
When checking operator: When binding output interface field "FIELD1" to field "FIELD1": Converting a nullable source to a non-nullable result;
This warning is showing in the DB2 stage...
But when ever I tried to change Nullability to Yes for these two fields then there are no warnings.... But in the table for this columns nullability is No....
really wondering... :cry: please help me........
premupdate
Participant
Posts: 47
Joined: Thu Oct 04, 2007 3:37 am
Location: chennai

Post by premupdate »

Hi,

Have you checked the outcome of join operation which might have null values in the columns extracted.
Cheers,
prem
Post Reply