Hi all,
I would want to know is there any way i can capture the accurate number of records which are inserted/updated to a DB2 table, after running the job?
Initially, I was using an after job sub-routine, which will get the link count, but i am not very sure whether it will be 100% accurate, as sometimes I have seen this scenario - 3 records loaded to DB2 stage, as per the designer but all 3 would be rejected, which can be seen in the director's log.
pls help me out.
Thanks in advance.
Vij
capture the count of number of records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
You can try doing this in multiple ways. Add a reject link in your target and subtract reject row count from main link row count (Pls. Feedback on this if you try this).
Using SQL statement in routine has been discusses many times in the forum, if you use search facility you will get all the required information about that.
Using SQL statement in routine has been discusses many times in the forum, if you use search facility you will get all the required information about that.
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: