Finding if value is null or not in binary data type 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
iwin
Premium Member
Premium Member
Posts: 99
Joined: Mon Apr 11, 2005 9:20 pm

Finding if value is null or not in binary data type field

Post by iwin »

Hi all,
I am trying to find if the value of a field which is defined as binary data type as column defination is null or not. I tried doing isnull , isnotnull, length=0 or trim(colname)='' in transformer after the join Stage but none is working.
Please let me know if u any idea how to handle null in this situation.

Thanks.
Every person you meet knows something you don't, Learn from them.
-- H. Jackson Brown
Post Reply