Conditional ABORT after 50 errors???

tomengers · Post by **tomengers** » Mon Jan 28, 2008 7:30 am

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

RAJARP · Post by **RAJARP** » Mon Jan 28, 2008 8:15 am

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

tomengers · Post by **tomengers** » Mon Jan 28, 2008 12:05 pm

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

narasimha · Post by **narasimha** » Mon Jan 28, 2008 12:47 pm

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

tomengers · Post by **tomengers** » Mon Jan 28, 2008 1:21 pm

Narasimha ...

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

thanks ...