Stage Variable in a Routine

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
samyamkrishna
Premium Member
Premium Member
Posts: 258
Joined: Tue Jul 04, 2006 10:35 pm
Location: Toronto

Stage Variable in a Routine

Post 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.
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

each routine has argument and which argument you put there is on your behalf, so you easily can do.
Wolfgang Hürter
Amsterdam
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Krazykoolrohit
Charter Member
Charter Member
Posts: 560
Joined: Wed Jul 13, 2005 5:36 am
Location: Ohio

Re: Stage Variable in a Routine

Post 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.
Post Reply