call custom user-defined,Routine or transform in job control

[talk2shaanc]

In one of my job, i wanted to call a routine(transform) in the job control to get a value then passing that derived value to a job invoked in the same job control.
I was geting error message: Array 'Routinename' never dimensioned.It was considering the 'Routinename' as an array, as the the call was something like : Var=Routinename(value1,valu2,value3)
Then i had to open Code of the routine/transform in the job control, and it was working fine.

I just want to know, is there some way to call a routine/transform, they way i did it in the first instance or its not possible and whenever i have such requirement, i will have to open up a routine code and add it in my job control.

[ray.wurlod]

You have to declare to your job control that the user-defined routine exists and supply argument placeholders and catalog name.

Code: Select all

DEFFUN RoutineName(Arg1, Arg2, Arg3) Calling "DSU.RoutineName"

The "DSU." prefix is DataStage's way of identifying user-written routines.

You simply can not use Transforms in your own code. What you can do is to copy and paste the derivation expression, and substitute variables or expressions for the Transform arguments. A Transfom is not a separately executable piece of code in the way that a Routine is.

[xcb]

Hi,

Here is one way of calling a custom routine from either Job Control code or another routine.

Code: Select all

DEFFUN MyRoutineName(Arg1, Arg2, ... , ArgN) Calling "DSU.MyRoutineName"

You can't reference a defined Transform as this is just an inline statement that gets placed into a Datastage Job at compile time.

[talk2shaanc]

Thanks, Ray & xcb