How to use or call a DSRoutine

[aschand]

Hi

Can anyone please tell me how to call or Use a DSRoutine in a Datastage job.

Thanks
aschand

[gateleys]

You call it by its name and a set of parameters, just as you would do in any other programming languages. If you mean 'where' to make the call from, it can be done from several places, eg. Derivation of a column in Transformer, before/after a stage or job, from a Routine Activity stage in a job sequence, etc.

BTW, what is the purpose of the routine that you intend to call?

[ray.wurlod]

There are different kinds of routine, including transformation function (callable from Routine Activity and server jobs), before/after subroutine (callable from job properties of server and parallel jobs and active stages in server jobs) and parallel routines (callable from Transformer stages in parallel jobs). Which do you have in mind? Parallel routines are created and compiled external to DataStage, and a descriptor is emplaced in the DataStage Repository mentioning the location and arguments of that routine so that it may be called.