Page 1 of 1
difference between routine and a function in datastage
Posted: Mon May 12, 2008 2:30 am
by uppalapati2003
Hi I having a dought that what is difference between a routine and a function in datastage
Posted: Mon May 12, 2008 3:00 am
by ArndW
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.
Posted: Mon May 12, 2008 6:21 am
by ray.wurlod
You have marked the job type as TX. Is that correct?
Posted: Mon May 12, 2008 6:32 am
by ArndW
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.