Page 1 of 1

Can I change a parameter in a value set at runtime?

Posted: Wed Feb 04, 2009 2:07 pm
by ag_ram
Hi
As we know we can create value set in the datastage and we can pass value set as one of the parameter in dsjob command from shell script.
Is it possible to change the value of one of the parameters of a value set in shell script?

**Note - Subject modified to be more descriptive - Content Editor **

Posted: Wed Feb 04, 2009 3:08 pm
by ray.wurlod
Not sure what you're asking here. Is the question about a "values file" read by a Parameter Set?

If so, when do you want to make the change? Can you give an example?

There is one absolute. Once a job is running, values of that job's parameter can not legally be changed.

Posted: Wed Feb 04, 2009 3:26 pm
by ag_ram
ray.wurlod wrote:Not sure what you're asking here. Is the question about a "values file" read by a Parameter Set?

If so, when do you want to make the change? Can you give an example?

There is one absolute. Once a job is running, values of that job's parameter can not legally be changed.
Yes. It is regarding the values file read by parameter set. I want to make changes before we kick off the job from script so that datastage job can run with the new values what we have set from script.

Posted: Wed Feb 04, 2009 6:11 pm
by ray.wurlod
That's fine, so long as you edit the values file (including saving changes and closing the file) before you kick off the DataStage job whose parameter set reads the values file.

Posted: Thu Feb 05, 2009 1:48 pm
by ag_ram
ray.wurlod wrote:That's fine, so long as you edit the values file (including saving changes and closing the file) before you kick off the DataStage job whose parameter set reads the values file.
I am talking about the value set which was created in datastage designer. Can we change the value of value set at script level before kicking of the job? If yes, How?

Posted: Thu Feb 05, 2009 4:37 pm
by ray.wurlod
So am I. Creating the Parameter Set causes an eponymous directory to be created in the project directory, and if you create values files these are stored in that directory as ordinary text files. Therefore you can edit them.

I will be presenting a DSXchange Learning Center webinar on Parameter Sets on Friday, February 20th. You will receive an invitation.

Posted: Tue Feb 10, 2009 2:45 pm
by ag_ram
Thank you very much. Information is really helpful. I appreciate it.