Hi Friends,
I have one problem in work, please can help to me in solution.
i have 3 TABLEs, i am storing data from 1st table to 2nd table. in the job. here i need start_time and End_time of job which is picking data from TABLE1 and putting data in to TABLE2
These Start_time and End_time i need to maintain in TABLE3.
regarding Start_time and End_time of Job
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 193
- Joined: Tue Sep 05, 2006 8:01 pm
- Location: Australia
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can also pick them up using DataStage macros (such as DSJobStartTimestamp) or equivalent DataStage API functions (such as DSGetJobInfo() function), both of which are available in expressions in job sequences.
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.