difference between routine and a function in datastage

uppalapati2003 · Post by **uppalapati2003** » Mon May 12, 2008 2:30 am

Hi I having a dought that what is difference between a routine and a function in datastage

ArndW · Post by **ArndW** » Mon May 12, 2008 3:00 am

Normally, a function is passed parameters and returns a value while routines are called with parameters and may change the return value of these parameters. This naming convention is broken somewhat in DataStage, as the "Routines" category actually contains functions. The only true routines you can declare in DataStage are the Before and After Subroutines, and those are hard-coded to accept only 2 parameters.

ray.wurlod · Post by **ray.wurlod** » Mon May 12, 2008 6:21 am

You have marked the job type as TX. Is that correct?

ArndW · Post by **ArndW** » Mon May 12, 2008 6:32 am

Plus it is in the General forum; so I assumed that both were wrong. I don't know TX - are the functions and routines in that product?

Please Note - the initial response only applies to Server and (partially) to PX.