regarding DSRUNJOB JOBCONTROL SUBROUTINE

vijaykumar · Post by **vijaykumar** » Wed Dec 27, 2006 4:23 pm

hi gurus,
THANKS VERY MUCH.
where should i use this utility RUNJOB(jobname).
my design is ODBC--->TRANSFORMER--->ODBC.
plz help me

cheers;
vijay

narasimha · Post by **narasimha** » Wed Dec 27, 2006 4:34 pm

vijaykumar wrote: where should i use this utility RUNJOB(jobname).
my design is ODBC--->TRANSFORMER--->ODBC.

Vijay buddy, why do you want to use this in your job? Reason?

us1aslam1us · Post by **us1aslam1us** » Wed Dec 27, 2006 4:37 pm

Is this the same Job you posted in the other thread or a different one.

Sam

vijaykumar · Post by **vijaykumar** » Wed Dec 27, 2006 5:08 pm

hi gurus,
thanks very much.
i just wanted to analyze how that function works.
i didn't make use of that in any one of my jobs wanted to see how this function works.
i know its completely wrong to analyze in such a manner, i thought when u dig deep, u can make use of these functions whereever necessary.
if anyone helps me out with the syntax and where this utility is used i really appreciate.i want to analyze how this function works out.
once again thanks.

cheers;
vijay

DSguru2B · Post by **DSguru2B** » Wed Dec 27, 2006 5:36 pm

Well thats good but at times, you just cross the bridge when you come to it.
DSRunJob() is a function and used in jobcontrol when you have to control the complete process. UtilityRunJob() is a utility provided by DataStage which runs the job and can be invoked inside the transformer. But it will be invoked for each and every row. There have been certain instances when you can use that. Search this website for the keyword 'UtilityRunJob'.
For syntax, go to the routine in your repository and read the help. It tells you everything.

narasimha · Post by **narasimha** » Wed Dec 27, 2006 5:38 pm

DSRunJob Function

Code: Select all

Syntax: ErrCode = DSRunJob (JobHandle, RunMode)

For more refer to DS Basic Guide page 280.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 27, 2006 7:28 pm

Source code is provided for all SDK routines. Examine the source code yourself.

vijaykumar · Post by **vijaykumar** » Wed Dec 27, 2006 10:03 pm

hi,
THANKS VERY MUCH.
cheers;
vijay