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