Transform vs Routine

snassimr · Post by **snassimr** » Sun Nov 20, 2005 10:25 am

Hi !

Does anybody can explane advantages and disatvanges using transform insteasd of routine . What difference between their using in Derivation Field ?

Thanks .

ArndW · Post by **ArndW** » Sun Nov 20, 2005 11:34 am

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.

ray.wurlod · Post by **ray.wurlod** » Sun Nov 20, 2005 2:53 pm

Search for more on this, but specify Transform with a capital "T".

snassimr · Post by **snassimr** » Mon Nov 21, 2005 1:56 am

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 ?

rkdatastage · Post by **rkdatastage** » Mon Nov 21, 2005 2:58 am

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