Friends,
Currently I'm working on a task which requires me to update the log table with the number of records processed each time the job is executed.
The design of the job is quite simple. It extracts data from 2 tables in the source db and writes to 2 tables in the destination db
STBL1==>Transformer1==>DTBL1
STBL2==>Transformer2==>DTBL2
The requirement is to update the log table with the number of records extracted from the source and written to the destination db.
I wrote a custom routine which uses "DSGetLinkInfo". But the problem is that I have wait for the completion of the job to invoke the custom routine to get the number of records processed in the link.
Is there any other way to get the number of records processed through a link from within the job
Thanks
Yamini
Alternate option to DSGetLinkInfo
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, but you have to wait to the end anyway to get the correct count.
The value of system variable @OUTROWNUM will be correct in the final row. Indeed it will be correct at all times on all output links.
The value of system variable @OUTROWNUM will be correct in the final row. Indeed it will be correct at all times on all output links.
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: 35
- Joined: Wed Oct 06, 2010 11:24 am
Re: Alternate option to DSGetLinkInfo
Hi Yamini,
It is not possible to get details before finishing the job. You can use DSJobreport afterjob subroutine to get any kind of details depends on the parameters you pass in the subroutine.
How this will help you...
It is not possible to get details before finishing the job. You can use DSJobreport afterjob subroutine to get any kind of details depends on the parameters you pass in the subroutine.
How this will help you...
Pacific