Hi folks,
I am trying to get the Current GMT Timestamp in one of my Parallel Jobs. The Target field is defined as a Timestamp on DB2 table.
When i use the CurrentTimestamp() function i get the Current Timetsamp of the Server where the Job is running.
Any ideas on how i can get the Vurrent GMT Timestamp using a xfm in DS Px Job.
Thanks
Current GMT Timestamp
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 38
- Joined: Wed Mar 17, 2004 1:16 am
- Location: USA
Current GMT Timestamp
..i did not invent many things..but i can make them Better..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In a Routine activity in a job sequence you can get it using System(99), which returns the system time in number of seconds since midnight Greenwich Mean Time (GMT), January 1, 1970.
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.