Passing values from job 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
phanikumar
Participant
Posts: 60
Joined: Tue Sep 20, 2011 10:44 pm
Location: INDIA

Passing values from job parameter

Post by phanikumar »

I am trying to run a job where it should prompt me with ten different values during run time. My question is how do I define these values for a single job parameter?

The logic should cater for the following three scenarios

It should allow me to run the job with all these ten values at once.

It should allow me run with the combination of these ten values.

It should allow me to run with each of these values individually.


Regards

Kumar
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Ten parameters.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Re: Passing values from job parameter

Post by qt_ky »

phanikumar wrote:I am trying to run a job where it should prompt me with ten different values during run time. My question is how do I define these values for a single job parameter?
With a single job parameter, you will be prompted a single time for a single value.

What is it you are actually trying to accomplish here?
Choose a job you love, and you will never have to work a day in your life. - Confucius
bashbal
Premium Member
Premium Member
Posts: 23
Joined: Mon Mar 01, 2004 12:26 pm
Location: Milwaukee, WI
Contact:

Parameter Set

Post by bashbal »

Look into creating a parameter set. You can group the 10 parameters into a single set. Then save frequently used value combinations with a descriptive "Value File Name".
When you run the job, you will be prompted for the param set name and it will fill in the 10 params with the saved values.
Lyle
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Re: Passing values from job parameter

Post by ray.wurlod »

phanikumar wrote:...it should prompt me with ten different values during run time.
DataStage jobs run as background processes - they do not prompt "during run time". Parameter values are resolved/supplied when a job run request is submitted.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

When you run the job manually you are 'prompted'. Command line / scheduled stuff... not so much.
-craig

"You can never have too many knives" -- Logan Nine Fingers
bashbal
Premium Member
Premium Member
Posts: 23
Joined: Mon Mar 01, 2004 12:26 pm
Location: Milwaukee, WI
Contact:

Post by bashbal »

Yes, when you run manually is what I meant. Craig, thanks for clarifying.
Lyle
Post Reply