Is there a way we can capture the rows written into target (file/DB) &
write that information to an audit table.
For example if we have a job like this
Sequential File --> Transformer --> DB2
Say 1000 records are written to oracle DB. I want to insert the value 1000 into an audit table (which is in DB2 but another schema).
We are not planning to use parallel/Server routines. Any other alternatives please?
We are running on 2 nodes and DataStage is in UNIX.
How to capture number of rows processed
Moderators: chulett, rschirm, roy
Craig's methodology is good as long as you just need approximate counts. However, any rejected records would throw the count off.
If you have to get an exact count that excludes rejected records, you might want to check out the DataStage Operational Database, to see if it is stored there. If not, then you'd have to do the routine calls you are trying to avoid!
If you have to get an exact count that excludes rejected records, you might want to check out the DataStage Operational Database, to see if it is stored there. If not, then you'd have to do the routine calls you are trying to avoid!