capture the count of number of records
Posted: Fri Aug 31, 2007 9:44 pm
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
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