calling more than 1 after-job routine

datastage · Post by **datastage** » Tue Oct 05, 2004 10:19 am

I need to clarify my understanding on this. It seems fairly obvious that you can only call 1 after-job subroutine in a particular job, but this has always seemed like weak functionality to me because there have been multiple times that I had the need to call 2 different routines back to back in an after-job.

Is this correct? Is there any workaround (other than the option of using a sequencer which will solve this, but add more development time) such as any job control that would execute after the final stage finishes?

Thanks,

kcbland · Post by **kcbland** » Tue Oct 05, 2004 10:43 am

Sure, use the AFTER-TRANSFORMER routine calls as well. Just pick the transformers that execute at the end of the job logic branches. Sometimes you have transformers closing at different times, because of how you constructed your job.

chulett · Post by **chulett** » Tue Oct 05, 2004 10:48 am

Can't you string multiple commands together when you do ExecTCL, much like you can with ExecSH, semi-colons and UNIX commands? Would that help?

tonystark622 · Post by **tonystark622** » Tue Oct 05, 2004 1:39 pm

Byron,

I usually write a new Routine and call all the after job routines from this one routine. Obviously, I just set this one new routine as the After Job routine.

HTH,
Tony