Update all Parameter Sets to actual values

Tampa_Indy · Post by **Tampa_Indy** » Fri Sep 04, 2015 1:39 pm

We are interested in making all parameter sets display the actual values that are contained in them within DataStage. e.g.

If we have 20 jobs with a parameter set $dsfasdfa.sdfasdf$ for the value of '2015', we want to be able to open any job and see 2015 instead of $dsfasdfa.sdfasdf$. Is it possible to perform a mass update of this kind, or does it require a manual process?

qt_ky · Post by **qt_ky** » Fri Sep 04, 2015 6:29 pm

Remember your topic about doing a find and replace inside a DSX file? This is the same type of scenario. I am afraid to ask why anyone would want to do that, so I'm not even going to ask.

Tampa_Indy · Post by **Tampa_Indy** » Sat Sep 05, 2015 10:41 am

So the answers is the dsx file. A silly question - how do I obtain access to this file if I cannot logon to the DataStage server? Is the dsx file truly the only way to accomplish this?

qt_ky · Post by **qt_ky** » Sun Sep 06, 2015 7:11 am

Yes, as far as I know. How to do so is outlined in your other topic.

If someone had hard-coded 2015 (or any value) into all the jobs, then it would make sense to do a find/replace-all to plug in parameters to make the jobs more flexible. It sounds like you all are trying to do the opposite though...

chulett · Post by **chulett** » Sun Sep 06, 2015 8:16 am

OK, I'll ask. Can you share for us why you are looking into this? There is some concern that with your limited knowledge of the tool that you might be making a decision that is not in your best interest long term. A full explanation could help arrive at a more proper solution.

Pet Peeve Alert:
We see that you just typed junk when you said "$dsfasdfa.sdfasdf$" - can you show us a real example of what you have in mind? Many times that helps better illustrates the issue, much more so than a string of random key presses.

Thomas.B · Post by **Thomas.B** » Mon Sep 07, 2015 4:05 am

To avoid that mass update thing you can put your global parameters to the value "$PROJDEF" and define their values on the DataStage Administrator client.
Updating the whole project will be much easier that way.

Tampa_Indy · Post by **Tampa_Indy** » Mon Sep 07, 2015 10:46 am

chulett wrote:OK, I'll ask. Can you share for us why you are looking into this?

This is a specific request from the powers from up above. Ideally, we would only wish to adjust the parameter sets in a specific folder and leave the rest of the jobs as-is. If I am understanding correctly, this is NOT possible? Correct?

ray.wurlod · Post by **ray.wurlod** » Mon Sep 07, 2015 5:07 pm

Just one folder is certainly possible. Create an export of just that folder's contents.

Tampa_Indy · Post by **Tampa_Indy** » Tue Sep 08, 2015 6:58 am

Thank you! That worked. So once we open the file using NotePad, do we simply do a 'replace all' for all parameter sets? Then conduct an import using DataStage?

chulett · Post by **chulett** » Tue Sep 08, 2015 7:01 am

Yes, being very careful of what exactly you change of course. And with good backups.

Tampa_Indy · Post by **Tampa_Indy** » Tue Sep 08, 2015 8:07 am

Thank you for the suggestions!