Hi,
I have a source ( sequential file) for which few mandatory checks are being performed. and i also have a error link to capture these in an error file. my requirement says that if the error file records exceeds 10% of the source records the job needs to be aborted.
Can anyone help me to get this done.
Thanks in advance,
Samba
aborting job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Welcome aboard. :D
Your problem is that you can't know in advance how many represents 10% unless you know how many are in the file to begin with. You could pre-process the row to get this count.
Direct the Reject output link from the Sequential File stage through a Transformer stage which tests whether this threshold has been exceeded and, if so, call a routine that aborts the job.
To my way of thinking, any requirement to abort a job should be challenged. You can process all the data, then check the row counts, then take any remedial/notification action required. It's a more streamlined approach.
Your problem is that you can't know in advance how many represents 10% unless you know how many are in the file to begin with. You could pre-process the row to get this count.
Direct the Reject output link from the Sequential File stage through a Transformer stage which tests whether this threshold has been exceeded and, if so, call a routine that aborts the job.
To my way of thinking, any requirement to abort a job should be challenged. You can process all the data, then check the row counts, then take any remedial/notification action required. It's a more streamlined approach.
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: