Hi,
I ran a job wherein I am loading data from source to target after some transformations. Now I want to load the summary of this already run job into a table using Datastage. How can I retrieve the number of records passing through each link in the already run job.
Also, in a Datastage job, is it possible to retrieve other job information like last run status, last run start and end time.
I know we can generate a report through dsjob command but I want to do it an a Datastage job/sequence.
Retrieving already run job information to populate a table
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 38
- Joined: Tue Jun 19, 2012 11:03 pm
- Location: India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a server job, or a BASIC Transformer stage in a parallel job, to invoke the appropriate DataStage macros to retrieve the information in which you're interested. If there's no DataStage macro, use a DataStage API function.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can find ETLStats here when you're ready.
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.