Page 1 of 1

Parameter Set usage?

Posted: Mon Mar 26, 2012 7:51 pm
by mczern
If I have several datastage jobs that have the same parameter set defined as an input parameter to the job and then add these jobs to a job sequence. Is there a way to specify that the same parameter set values (a set of values with the same name) be used by all of the jobs within the sequence? Or, are the jobs supposed to have the parameter set subcomponents defined and the values of those subcomponents are assigned values from the parameter set defined in the Job Sequence?

Posted: Mon Mar 26, 2012 9:24 pm
by ray.wurlod
Two solutions.

One is to leave the Parameter Set "value" as (as defined) throughout.

The other, really useful if you want occasionally to use different values, is to make use of "values files" for the Parameter Set. In this case use the name of the values file instead of "(as defined)".

Posted: Mon Mar 26, 2012 9:41 pm
by mczern
As always, Thanks Ray for the info!

I was playing around with the jobs and realized that if I have a Sequence with the Same Parameter Set name defined, I can click on the properties of the Job stage, click on the Parameter Set within the stage and click on the Insert Parameter button and it automatically assigns the Sequence parameter set info to the job stage parameter set. I was able to cascade the definition throughout my Job Sequence.