Difference in Routines and Transforms

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
raghu.chandra
Participant
Posts: 13
Joined: Sun Nov 19, 2006 8:40 am
Location: Mumbai

Difference in Routines and Transforms

Post by raghu.chandra »

Hi,

What is difference between Routines and Transforms.

Thanks,

Raghuraj
Raghuraj Singh Chandra,Software Engineer
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

The original difference (up to Version 3.0) was very important. Those Times a routine could not be used directly but hat to be wrapped into a Transform. Nowadays this use makes no difference. A Routine is more easy to handle. A Transform is a bit quicker. If you change a Routine and compile it it will work the way in every Job thereafter without a new compilation of the Job. For to use a changed Transform you have to recompile all Jobs where you want to use the new version.
Wolfgang Hürter
Amsterdam
ameyvaidya
Charter Member
Charter Member
Posts: 166
Joined: Wed Mar 16, 2005 6:52 am
Location: Mumbai, India

Post by ameyvaidya »

I also suspect (But do not have enough info to confirm) that a routine could have the housekeeping overhead akin to a procedure or function call while a transform is more like a macro that is expanded inline with the actual transformer code.
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes it does, but it's negligible and only incurred on the first row processed.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply