Constraint to abort job

[ady]

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

[ady]

The condition is col1 = col2


ie: if col1 <> col2 then ABORT JOB

[ganesh123]

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

[chulett]

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

[ganesh123]

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....

[chulett]

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.

[DSguru2B]

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.

[chulett]

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

Fixed that for ya.

[ganesh123]

I guess I am not hacking the topic
So Craig something like this in Shell script ?

Code: Select all

count= wc -l bad.file
if ($count>0)
then
ABORT
else
continue
fi

Which utility or function of DS has to be called in ABORT in above code?

[chulett]

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

[DSguru2B]

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

Fixed that for ya.

Thanks Craig.

[ganesh123]

DHANYAVAD SIRJI :D

[DSguru2B]

DHANYAVAD SIRJI :D

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

[chulett]

De nada.

[kumar_s]

De nada