Hi All,
I have sequence of jobs which takes current date as ap parameted to run.
and once those sequence of jobs complete i need to updated the end datetimestamp ,i tried using a shaned container which will pass sysdate and time from dual and updated the table ,but when the job completes i can see the start date timestamp not the end date timestamp in the database .can any one tell me if there is any function or routine for updating Enddate timestamp like Dsstarttimestamp i dont remember the exact name.
Regards
Tausif
Updating a end date timestamp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Mon Feb 27, 2006 10:34 pm
- Location: Chennai
- Contact:
Updating a end date timestamp
Mohammed Tausif Hussain Sheikh
Cognizant technologies,Perungudi
Chennai
Cognizant technologies,Perungudi
Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Easiest would be a server job (called from the job sequence at the end) to perform this task. It could interrogate the system clock directly (via the Date() and Time() functions for example) rather than selecting sysdate from dual.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.