Problems running a routine to compile a single job

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

CharlesNagy
Premium Member
Premium Member
Posts: 66
Joined: Mon Feb 21, 2005 10:40 am
Location: Paris

Post by CharlesNagy »

kcbland wrote:Just FYI, the job control goodies on my site has the major job control function that features compilation of jobs at startup as well as prior to running a job. My point is that compiling a job is not your problem, it's the code calling the compiling routine. That's why I thought clearing the status file was interfering with your running the same job.
Thanks Ken,

After you very kindly gave me access to your site, I was able to download the "Compile all jobs" code, and compare it with the code I had inherited. There was one slight difference, whether inadvertant or not.

The section right at the beginning of the code I was using says:

MyJobNo = JobName
SUBR = DSR.SUB.JOB
Key = DSR.SUB.JOB.GETNO
CALL @SUBR(Key, MyJobNo)

In your code it says:

MyJobNo = DSJobName

This makes all the difference. The routine now works when called from job control. (It always worked stand alone, ie in test mode)

I am going to mark this resolved now.

Thanks Ken!
Post Reply