DSXchange

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

Ten parameters.

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?

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.

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.

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

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