Page 1 of 1
Transform vs Routine
Posted: Sun Nov 20, 2005 10:25 am
by snassimr
Hi !
Does anybody can explane advantages and disatvanges using transform insteasd of routine . What difference between their using in Derivation Field ?
Thanks .
Posted: Sun Nov 20, 2005 11:34 am
by ArndW
A transform is a 1-line function that is actually replaced in the job, a routine is a separate function call that is compiled and stored elsewhere.
If you change a transform then you need to recompile any jobs that use it. If you change a routine you only need recompile it once and the new version will be used by all jobs that call it.
Posted: Sun Nov 20, 2005 2:53 pm
by ray.wurlod
Search for more on this, but specify Transform with a capital "T".
Posted: Mon Nov 21, 2005 1:56 am
by snassimr
Thank you all.
I did some check and really using transform and its more faster then routine. But writing any derivation on place without calling transform or routine te fastest way.
ArndW : The call to transform replaces with the code after compilation ?
Ray : People confuse Transform and Transformer and its difficult ot find somthing specific about transform. Did you succeed with another string search ?
Posted: Mon Nov 21, 2005 2:58 am
by rkdatastage
The basic difference between a Transform and a Routine is
Transform is a inline function which is having one line of code
where as a routine is multiple line of code function
both are reusable
RK