lookup on null field giving 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
saidvs
Participant
Posts: 12
Joined: Thu Jul 28, 2005 10:41 am

lookup on null field giving warning

Post by saidvs »

hi..

when doing a lookup on a nullable field, I am getting the following error..

When binding output schema variable "outRec": When binding output interface field "XXXX" to field "XXXX": 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.

Can you give me suggestions how to get rid of the warning...

Thanks,
Venkat
us1aslam1us
Charter Member
Charter Member
Posts: 822
Joined: Sat Sep 17, 2005 5:25 pm
Location: USA

Post by us1aslam1us »

It is giving error because you are sending the column with out handling its null values.Either use IsNull() or NulltoEmpty() in the transformer stage or handle_null() in the modify stage for that particular field before doing lookup.
I haven't failed, I've found 10,000 ways that don't work.
Thomas Alva Edison(1847-1931)
Post Reply