Warring while finding Max, Min Date - Aggregator Stage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
K.A.R.PAULSON
Participant
Posts: 23
Joined: Sun Aug 01, 2004 2:33 am
Location: Dubai
Contact:

Warring while finding Max, Min Date - Aggregator Stage

Post by K.A.R.PAULSON »

In a job I am trying to find out the maximum and minimum date from the given date field. For that I was made a job with Aggregator stage.
I am getting the required out put, but I am getting multiple warring in the log file. The warring message I am listed below.

Acc005_Aggr_MaxMinDate_TopAcc..Aggr_MaxMin_Date: At row 1991, link "Input_Agg", while processing column "Output_Agg.MIN_FIRST_SHIP_DATE"
Value treated as NULL
Attempt to convert String value "" to Long type unsuccessful


Please let me know how to handle this warring.

Thanks and regards
Regi
T42
Participant
Posts: 499
Joined: Thu Nov 11, 2004 6:45 pm

Post by T42 »

Don't pass invalid data to the aggregator stage. Use a transformer's constraint. That's all.
Post Reply