Parameter Set - Assigning Values as Runtime via script

[synsog]

We have a simple parallet job
Src File --> Transformer --> Oracle Table

First we had all the parameters deifned in the job and all the values are passed at runtime via a unix script and it all works fine.

Now we added a Parameter Set to this job instead of defining the parameters in it and am trying to run the job the same way by passing parameter values at runtime once the job is triggered via a script but we get this error

Error -3 getting information for parameter 'pProcessDate'

Status code = -3 DSJE_BADPARAM
dsjob run command Status= 255

pProcessDate is the first parameter defined in the parameter set. So it means the values are not being assigned to it.
On settting default values in the parameter set does not help either and we still get the same error.

Has anyone faced a similar issue and if yes how was it resolved?

[pravin1581]

How are you assigning the values to the parametr set, PS work differently. Th values are alreday defined and one needs to pass the value file name in the script when calling the parameter set.

[ray.wurlod]

The error message indicates that whatever value is being passed to pProcessDate is not a valid date or is not a valid date format. What is your default date format? (It's probably YYYY-MM-DD.)

[synsog]

The date format seems correct.

I am trying to pass the values to the parameters via a script that is called from within the main job run script. If this is not the way we can assign values to parameter set, how else can we do it?

[ray.wurlod]

Please explain exactly how you're doing that.

You can not simply "set" the value of a parameter in a parameter set externally, other than when you're creating it.

What you can do is declare the parameter set to have one or more values files, and write to those files, then declare the file name to be the "value" of the Parameter Set when the job run request is issued.

[kduke]

From a script you can assign parameter values to a parameter set one at a time SetName.ParamName=ParamValue or SetName=SetValue. I would have to lookup the exact syntax if you need it.