Can we use User-defined server routines in parallel jobs
Moderators: chulett, rschirm, roy
Can we use User-defined server routines in parallel 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
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
If the routines are of type "before/after subroutine" then no, you can not use these from a BASIC Transformer stage expression.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ray.wurlod wrote: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.....
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 10
- Joined: Wed Apr 16, 2008 7:39 am
- Location: USA
Re: Can we use User-defined server routines in parallel jobs
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.
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.
anusha wrote: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
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
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.
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
ray.wurlod wrote: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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: