Routine output as 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
Jaydev
Participant
Posts: 13
Joined: Thu Nov 01, 2012 6:28 am
Location: Hyderabad
Contact:

Routine output as parameter

Post by Jaydev »

Hi forum,

I had a sequnecer and i am using a routine in it. In the same job if i want to use that routines output, to be used as a parameter, how can i achieve that.

I know that Ans will be storing output value, but how to take it to next stage to be used as a parameter.

I will be having a job activity stage which will pass this parameter value to the job inside.

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

Post by chulett »

Open the parameter helper in the Job Activity stage for that field, one of the options it will show you is the output from the Routine Activity stage.
-craig

"You can never have too many knives" -- Logan Nine Fingers
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

if the return value other than 0 is giving problem try calling it from the user variable activity.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Jaydev
Participant
Posts: 13
Joined: Thu Nov 01, 2012 6:28 am
Location: Hyderabad
Contact:

Post by Jaydev »

Thanks chulett and kunal.

My approach is, In the job activity stage itself, I called the routine directly where we assign parameters. This eliminated before routine stage and also I got routine output directly stored to my parameter.

Thanks All.
Regards,
Jay
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Or that. :wink:

That option wasn't always supported, btw.
-craig

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