DSXchange

Hi Gang ...

Been reading posts but do not see straight-forward way to say "if I have more than 50 validation errors (out of range, etc.) then I want to abort the job". I understand about an after job routine, but is there a way within DataStage to accomplish this?

Thanks in advance ...

... tom

Hi Tom,
If my understanding is correct,you can go for the following solution.
After hitting the run option,a window would open.In that select "LIMITS" tab and then select "Abort Job after"and give the number of warnings as 50.But am not sure that this is what you have asked.
regards,
rajarp

Rajarp ...

Thanks ... I know about the LIMITS method, but was hoping there was another more direct way such as IF ERROR_CNT > 0 MOVE 3 TO ABORT_STATUS.

Guess I will have to chalk that up to wishful thinking ...

... tom

One way of doing this - Setting up a reject link. In the constraints, specify Abort after row value 50.

Narasimha ...

Ha ... great answer ... so simple I never thought of it.

thanks ...