Passing value to parameter

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
vamsi.4a6
Participant
Posts: 334
Joined: Sun Jan 22, 2012 7:06 am
Contact:

Passing value to parameter

Post by vamsi.4a6 »

I developed a server routine which will return a value. I want to pass that value to a parameter in the Job in the Job sequence.I Know I have to use routine activity but i do not Know how to proceed furthur?
DS_SUPPORT
Premium Member
Premium Member
Posts: 232
Joined: Fri Aug 04, 2006 1:20 am
Location: Bangalore

Post by DS_SUPPORT »

Call the routine using Routine Activity, and Introduce a Job Activity and call the actual job. The job activity will show all the available job parameters. For the parameter you are interested in, select the Routine Activity.$returnvalue
vamsi.4a6
Participant
Posts: 334
Joined: Sun Jan 22, 2012 7:06 am
Contact:

Post by vamsi.4a6 »

@DS_SUPPORT

Thanks for your Input
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Just to be anal, the actual value is $ReturnValue. And don't forget that any non-zero return value will be considered a failure of the routine if you have the 'Automatically handle' option enabled.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply