Time Comparision
Posted: Wed Feb 20, 2008 9:40 pm
Hi,
How to we compare the source column timeStamp with current timeStamp.
For example i have the source column'ABC' which was updated in database 7:30PM.I am using this column as a target column,and i just want to compare this column time stamp in database with current datastage job time stamp whether it is morethan 2 hours or lessthan 2 hours.If it is morethan 2 hours and its not reached the specified conditions the datastage job should be able to send a e mail notification for the service personnel.
Thanks in advance,
Vijay Katneni.
How to we compare the source column timeStamp with current timeStamp.
For example i have the source column'ABC' which was updated in database 7:30PM.I am using this column as a target column,and i just want to compare this column time stamp in database with current datastage job time stamp whether it is morethan 2 hours or lessthan 2 hours.If it is morethan 2 hours and its not reached the specified conditions the datastage job should be able to send a e mail notification for the service personnel.
Thanks in advance,
Vijay Katneni.