how to write a customized function in datastage.

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
suneyes
Participant
Posts: 82
Joined: Mon Jul 21, 2008 8:42 am

how to write a customized function in datastage.

Post by suneyes »

Hi I have a requirement where I need to keep perform arithmatic operations on 5 i/p columns of a transformer stage.which cannot be done in a single step.
is there any way,I can write a custom function in datastage where I can use intermediate results for further processing and finally place the desired output as an o/p column??

any pointers regarding this is highly appreciated..
sun
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Create your functions in C++ and compile and link them.

Create a DataStage "parallel routine", which is an entry in your repository that tells DataStage that your function exists and the arguments it requires and returns.

Make sure that your shared library search path includes the directory in which your library/object resides.

Invoke your function in the parallel Transformer stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
suneyes
Participant
Posts: 82
Joined: Mon Jul 21, 2008 8:42 am

Post by suneyes »

Thanks ray..
sun
Post Reply