Job Aborted while comparing 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
verify
Premium Member
Premium Member
Posts: 99
Joined: Sun Mar 30, 2008 8:35 am

Job Aborted while comparing dates..

Post by verify »

I have requirement where i need to compare two dates say ReportDate and StartDate.

I'm comparing thie two dates in a filter stage as "ReportDate > StartDate".
StartDate is present in the input dataset of format yyyy-mm-dd and ReportDate is a parameter for which the value i'm giving as '2008-02-01'.

But my job is aborting throwing error at "-".

Do i need to convert into some format for comparison..

Please provide inputs to this...
RK Raju
Top
bart12872
Participant
Posts: 82
Joined: Fri Jan 19, 2007 5:38 pm

Post by bart12872 »

You cannot compare two dates in a filter. Use a transformer and the fonction DaySinceFromDate(date1,date2)

You can compare 2 dates in a filter stage only if the second date is explicitly specify. ex : DaySinceFromDate(date1,'2009-02-27')

Martin
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”