what is the exact difference between routine and transfroms?

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
mallikharjuna
Participant
Posts: 81
Joined: Thu Nov 30, 2006 7:46 am
Location: india

what is the exact difference between routine and transfroms?

Post by mallikharjuna »

what is the exact difference between routine and transfroms?
MALLI
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Diff between Routine and Transform is, transform code will be included during the time of job compilation. Where as Routine will be called each time. Hence the startup time for the job using Routine may be more when compared to Transform.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Also, if the definition of a Transform changes, every job that uses it has to be re-compiled, whereas if the logic of a Routine changes, only the routine itself has to be re-compiled (unless the number of arguments changes).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Since the code of the Transform is included during compilation, any change to Transform after that will not affect the current job settings. Unless job is recompiled, which will again look for the latest available code of Transform.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

A simple search would have turned out the answers.
Post 1
Post 2
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply