handel null with dates

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
consulting
Participant
Posts: 50
Joined: Fri Dec 21, 2007 3:24 am

handel null with dates

Post by consulting »

Hi
I want to take max of two dates in transformer.
the problem is i am having some rows as null. so the record dropped.
My req is i have to find the max of the two dates
Last edited by consulting on Fri Nov 14, 2008 11:02 am, edited 1 time in total.
balaji
gateleys
Premium Member
Premium Member
Posts: 992
Joined: Mon Aug 08, 2005 5:08 pm
Location: USA

Re: handel null with dates

Post by gateleys »

consulting wrote:Hi
I want to take max of two dates in transformer.
the problem is i am having some rows as null. so the record dropped
May be you could assign 9999-09-09 to any null dates.
gateleys
Post Reply