Error in Transformer

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
akansha123
Participant
Posts: 9
Joined: Sat Mar 18, 2006 1:53 pm

Error in Transformer

Post by akansha123 »

Hi,

I have a i/p column(Col1) which is not nullable and also same o/p column(Col2)with not nullable,same datatype and length.Iam using tranformer for mapping.But iam getting the following error.


---When checking operator: When binding output interface field "Col1" to field "Col2": 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.
[/b]



Both the tables are in nateeza.

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

This is an alert to a potential deficiency in your design - an input column is nullable and an output column to which it is mapped is not.

If a NULL arrives in this column it might engender a fatal error.

You need to adjust nullability appropriately, or to provide explicit null handling and/or default value on the output column derivation/properties.
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