DSXchange

What sort of a "routine" are you talking about here? Is it a DataStage server routine, or perhaps a c++ program linked in as a plugin?

It is a server routine...

From a server routine it is preferable to use the builtin API calls, in your case it would be:

• DSAttachJob()
  DSSetParam()
  DSRunJob()
  DSDetachJob()

To see how the calls work, create a new Server job. Go into the Job Control tab and, at the top, select the sequence you wish to call and click "Add Job". This will add standard job control to the window and you can cut-and-paste it (after editing) to your routine.

Being new, why do you think you 'need' to do this from a routine? It's not the most straight-forward approach you could take.

This is one of the requirements that, we have to use routine to call the job. I have used dssetparam and configured the parameters.

Thanks for all your help..


Linda

How do you intend to invoke the routine in the first place ?

lindatgeorge wrote:This is one of the requirements that, we have to use routine to call the job. I have used dssetparam and configured the parameters.

<rant>Resist stupid requirements!</rant>