Remove duplicate strange issue

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
mandyli
Premium Member
Premium Member
Posts: 898
Joined: Wed May 26, 2004 10:45 pm
Location: Chicago

Remove duplicate strange issue

Post by mandyli »

Hi

we are in the process of moving jobs from 8.0 to 9.1.

we are seeing following fatal error from Remove duplicate stage.

"main_program: Error when checking operator: "nulls" property only applies to nullable fields; on key "aaa_code: {case=sensitive, nulls=first} "


Is this anything issue with data or issue with 9.1?


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

Post by ray.wurlod »

This was not properly detected in 8.0. It is now correctly detected. It shouldn't be a problem, but why would you specify nulls first when the field is not nullable?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
moalik
Participant
Posts: 39
Joined: Thu Sep 15, 2011 8:15 am
Location: Melbourne

Post by moalik »

Could you let us know whether the key column is "Nullable" ?
Mohsin Khan
Datastage Consultant
mandyli
Premium Member
Premium Member
Posts: 898
Joined: Wed May 26, 2004 10:45 pm
Location: Chicago

Post by mandyli »

Yes.

we have added Modify stage and fix this issue.


Thanks
Man
Post Reply