Can we use User-defined server routines in parallel jobs

[anusha]

Hi all,

Please help in resolving this issue,

I have created some user-defined server routines.I need to use these routines in parallel jobs......

SO i created a a parallel job using Basic Transformer Stage.I am able to see all my server routines through DS Routines in Basic TYransformer Stage but when trying to use them in derivation of the columns , the jobs is just giving the output as like the functionality of the routine is not incorporated........

So please clarify me whether can i use the user-defined server routines in parallel jobs using Basic Transformer Stage

Thanks in Advance
Anusha

[ray.wurlod]

If the routines are of type "transform function" then yes.
If the routines are of type "before/after subroutine" then no, you can not use these from a BASIC Transformer stage expression.

[anusha]

If the routines are of type "transform function" then yes.
If the routines are of type "before/after subroutine" then no, you can not use these from a BASIC Transformer stage expression. ...

Thanks Ray,

Yes the routines are of Transform type..........but even then functinality is not incorporated.....the output is just the same like the one with iut using the fuction.....

[ray.wurlod]

The fault may be in the Routine code. Does it return its input argument unchanged? Is the Ans variable assigned a value? How are you calling the routine from the BASIC Transformer stage? In particular are you using the Expression Editor to create your expressions?

[vidya_6_2000]

That is interesting, I am not able to see my server routines in my parallel job tx stage. Did you do something special to be able to see it. I am having to re-write all my server routines for using in my parallel job.

[sreddy]

Hi Anusha

The BASIC routines will work on Server jobs only.
In Datastage PX we have Two types of transformers
1. Basic Transformer
2. Parellel Transformer

as per my knowledge you may not use the Basic Transformer in Parellel jobs.

Hi all,

Please help in resolving this issue,

I have created some user-defined server routines.I need to use these routines in parallel jobs......

SO i created a a parallel job using Basic Transformer Stage.I am able to see all my server routines through DS Routines in Basic TYransformer Stage but when trying to use them in derivation of the columns , the jobs is just giving the output as like the functionality of the routine is not incorporated........

So please clarify me whether can i use the user-defined server routines in parallel jobs using Basic Transformer Stage

Thanks in Advance
Anusha

[Minhajuddin]

You *can* call server routines in a parallel job from a basic transformer stage, As Ray pointed out earlier the problem may be with the routine. Create a simple routine which accepts a dummy parameter and returns a hardcoded string "HelloWorld" to the output. Test it using the basic transformer.

[ray.wurlod]

Check also that you have indeed selected a BASIC Transformer stage rather than a parallel Transformer stage.

[anusha]

Check also that you have indeed selected a BASIC Transformer stage rather than a parallel Transformer stage. ...

Thanks all,

Thanks for the inputs........i am able to use my routines in Basic Transformer stage of Parallel jobs.......

As ray mentioned the problem is with the condition i incorporated in routines

[ray.wurlod]

Perhaps you could mark this thread as Resolved.