Page 1 of 1

Stage Variable in a Routine

Posted: Mon Dec 03, 2007 9:46 am
by samyamkrishna
How do i use a stage variable in a routine.
I want to use a column name in the transformer in the routine is there any way i can do it.

Posted: Mon Dec 03, 2007 9:54 am
by WoMaWil
each routine has argument and which argument you put there is on your behalf, so you easily can do.

Posted: Mon Dec 03, 2007 9:57 am
by chulett
You use the value of a stage variable in a routine by passing it to it as an argument. Or did you mean something else?

Re: Stage Variable in a Routine

Posted: Mon Dec 03, 2007 12:35 pm
by Krazykoolrohit
samyamkrishna wrote:How do i use a stage variable in a routine.
I want to use a column name in the transformer in the routine is there any way i can do it.
I assume you want to pass the column name instead of the value into the routine? right? Why cant you hard code the column name and pass as a string? why you need that routine in a job when it is going to process the same thing for every row?

PS: Plz try and be specific in your requirments. Will help you to get faster answers.