Calling a DataStage Job from a Routine.

deep · Post by **deep** » Mon Apr 12, 2004 1:57 pm

Hi

I have written a routine to call a DataStage job using the regular
DSAttachJob and DSRunJob functions.

When i call this routine from the transfomer of my main Datastage job,
the Routine(and the job that is called from it) runs successfully the first time(i.e for the first row returned extracted from the DB of the main job) but it errors out the second time.The error i see in the job log of my main job is(**Unable to Attach to job**).I even tried resetting the job status each time i run it but still i get the same error.

I was wondering if any of you guys came across this problem??
I was also wondering if the idea of calling the Datastage Job from a Routine
in itself Wrong??

Thank You!

chulett · Post by **chulett** » Mon Apr 12, 2004 1:59 pm

You have to 'detach' the job when you are done. Sounds like you are missing that step.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 12, 2004 3:39 pm

The advice about DSDetachJob is correct.

Do you really want to run this other job for every row you process in your main job? Is there a more efficient way that you could design this? (I suspect the answer to that is yes.)