Page 1 of 1

difference between routine,transform and function?

Posted: Thu Feb 22, 2007 5:42 am
by mallikharjuna
what is the difference between routine,transform and function?

Posted: Thu Feb 22, 2007 6:47 am
by ray.wurlod
I assume you're referring here to the terms used in the Expression Editor's operands menu.
  • A routine is a separately compiled, stand-alone piece of DataStage BASIC code that is stored in the Routines branch of the Repository.

    A transform is a DataStage BASIC expression, not separately compiled, that is stored in the Transforms branch of the Repository.

    A function is one of the many intrincsic functions within the DataStage BASIC language.