DSJOB - special case

TonyInFrance · Post by **TonyInFrance** » Wed Apr 24, 2013 7:36 am

Hello

I am launching a Datastage job using the dsjob command and assigning a particular parameter set. However I see that due to certain restrictions I need to at times choose a different value that is in the parameter set (only one parameter)

This is based on an if then condition.

Thus my question is: is it possible to selectively override parameter values in a parameter set when launching jobs using dsjob and a parameter set?

Thanks guys

Tony

chandra.shekhar@tcs.com · Wed Apr 24, 2013 7:56 am

Yes, You can override the values of parameters if you are passing the values through scripts.
And if you don't pass any value, then the default value will be picked up which is set in the job.
We are also doing the same in some of our jobs.

TonyInFrance · Post by **TonyInFrance** » Wed Apr 24, 2013 8:01 am

Thanks bro.

BI-RMA · Post by **BI-RMA** » Wed Apr 24, 2013 8:36 am

Hi Tony,

sorry to interrupt as you've already marked this topic resolved. Did you really succeed in replacing a single value from a parameter-set by using a Unix-script - or did you just take Chandra's response for granted?

If you did succeed I'd like to have some more information how you did it, because it seems almost impossible to me...

One thing I know is possible - but not a solution my current client likes too well - is to manipulate the values in the value-file at run-time. See this post for details.

TonyInFrance · Post by **TonyInFrance** » Wed Apr 24, 2013 9:00 am

Hi Roland

I think I misunderstood Chandra's solution... but then I realized that I had not explained my situation clearly. However you seem to have understood my exact requirement.

Chandra's solution was to either use the entire parameter set by specifying the VALUE or omit it altogether. the the latter case I don't really know what would happen.

What I wanted initially was to choose a VALUE for the parameter set BUT override one of the parameter values contained in the parameter set.

I admit I don't think this is possible.

Regards

Tony

chandra.shekhar@tcs.com · Wed Apr 24, 2013 9:41 am

My bad..

I think I misunderstood the post too.
As suggested by Ray in that post, we can change the values defined in values files belonging to the Parameter Set, if "(As pre-defined)" is not set.
Sorry again for the inconvenience.

ray.wurlod · Post by **ray.wurlod** » Wed Apr 24, 2013 3:55 pm

You can also use "dot notation" for example

Code: Select all

-param MySet.MyParam=1