How to call the DS Routine in batch job?

Peace · Post by **Peace** » Tue Sep 19, 2006 9:16 pm

Dear All,

May I know whether we can call the DS routine in batch job or not?
If yes,could u pls let me know how to call it?

Thanks,
peace

kduke · Post by **kduke** » Tue Sep 19, 2006 10:03 pm

Search on DEFFUN. This has been covered a lot. There are lots of examples in EtlStats and on this site.

Kirtikumar · Post by **Kirtikumar** » Tue Sep 19, 2006 10:09 pm

What is a batch job here?

If it is referring to the job sequence in DS, then yes you can call it. Routine activity can be used for that.

If batch job means a shell script to call the DS jobs, then probably you have to use the indirect way i.e. create dummy job sequence and then call it in the script.

kduke · Post by **kduke** » Wed Sep 20, 2006 7:23 am

A true batch job is what was used before sequences. That is what VMark originally called them. A batch job is a job which has no stages. It is all job control code.

You are correct if this is not what they meant then my answer is wrong.

Kirtikumar · Post by **Kirtikumar** » Wed Sep 20, 2006 9:45 pm

In some of the project in my org people were using this kind of batch, but they were calling it as job control. So I was unaware about this term from DS pov.

kduke · Post by **kduke** » Thu Sep 21, 2006 7:12 am

Job control is valid as well as batch job.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 21, 2006 3:22 pm

A Batch in DataStage is job control code that is created using the Director client.

Peace · Post by **Peace** » Thu Sep 21, 2006 6:22 pm

Yes.I am saying about Job control.
Is there any way to call the routine function from there if I am not using Sequencer?

Thanks for all of your time,

ray.wurlod wrote:A Batch in DataStage is job control code that is created using the Director client.

ray.wurlod · Post by **ray.wurlod** » Fri Sep 22, 2006 4:12 am

Yes, simply invoke it as a function. However, you will need a DEFFUN declaration to inform the compiler that the name followed by a left parenthesis is that of a function rather than that of a dimensioned array.