DSXchange

Hi,

I am working on a job in which there is a condition, Which if not satisfied should abort the job. Can I do this ?

I have this job in a sequence, so when the job fails ....the "fatal" link should be executed.

Please help .. thnx

The condition is col1 = col2


ie: if col1 <> col2 then ABORT JOB

Use a reject link in your job going to a Seq file. If data comes in Seq file abort job using UtilityAbortToLog(%AbortMessage%) in TX

You don't need to do anything 'special' - just set the Abort After Rows value to 1 in the Reject link constraint.

Craig is there any option that if we want to collect all the rejected rows in a separate file and then do ABORT later after collecting all rows ?

In this way we can know how many and which rows are bad....

Sure, that's a different requirement. I'd setup something 'after job', a routine that checks the row count down your reject link, let's say, and then aborts the job if the count is non-zero.

In the stage variables, scroll right , you should be able to see 'Abort After' column. If you dont have that, then you can utilize UtilityAbortToLog() as others have noted.

DSguru2B wrote:In the constraints, scroll right, you should be able to see 'Abort After' column.

Fixed that for ya.

I guess I am not hacking the topic
So Craig something like this in Shell script ?
Which utility or function of DS has to be called in ABORT in above code?

Something like that or a call to DSGetLinkInfo using the DSJ.LINKROWCOUNT InfoType. And you could call either UtilityAbortToLog or DSLogFatal.

chulett wrote:

DSguru2B wrote:In the constraints, scroll right, you should be able to see 'Abort After' column.

Fixed that for ya.

Thanks Craig.

DHANYAVAD SIRJI :D

ganesh123 wrote:DHANYAVAD SIRJI :D

...means, "Thank You Sir" with respect

De nada.