Hi all is there any way which i can get previous timepstamp for the field.
Example In a table i have a field Last_upt_tmpst with this field i need to put constraint in my job as last_upt_tmpst> @previous_upt_tmpst
But i dont want to declare variable as @previous_upt_tmpst..
Is there any way which i can get by any Convert function.
Please help me on this.
How to get previous timestamp field
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
So you need the equivalent of the timestamp of this time on the previous day to a particular timestamp? Download the routines from this site and you will find one (AddDaysToTimestamp) that does timestamp arithmetic. Use -1 as the Days argument.
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.
Sounds like you need to create a job to capture this 'lst_updt' and stash it somewhere like USERSTATUS. Then use a Sequence job to run the two Server jobs and pass it as a Job Parameter to the second job. Use the job parameter in the constraint.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers