Add new parameter and remove default value from Jobs

bkamila · Post by **bkamila** » Mon Sep 24, 2007 6:48 pm

Hello DataStage Gurus!!!!!!!!!!!

We have tasks to --
1. Add 2 new job level parameters to 300 DataStage jobs
2. Remove Default Values of Parameters for 300 DataStage jobs

We want to know -- what is easy and safe way to achieve above objectives without manually changing each job. Our colleagues have been taking few options, for example:
1. use utility (CopyParameter) or any other utility available,
2. extract xxx.dsx and manually add the Parameter and manually remove the default value,
3. come up with an awk script the will interrogate and loop thru each job of the xxx.dsx file. Interrogate for changes.

Ray you are DataStage guru. Is it possible for you to suggest a ready made solution which is comparatively safe and less time consuming?

My email is bkamila@optusnet.com.au. Feel free to write to me directly.

Cheers, Bana

ray.wurlod · Post by **ray.wurlod** » Mon Sep 24, 2007 7:27 pm

Bana, feel free to send money for free receipt !

There is a tool called Parameter Manager for DataStage available from the folks who run this site, but I am not sure that it is still available. There is a forum here at DSXchange relating to it.

Vincent published a blog on hacking job parameters without losing your mind, which might serve as a useful source of ideas.

My business can do that kind of custom coding, but it would perforce be on some kind of commercial arrangement.

changming · Post by **changming** » Mon Sep 24, 2007 10:17 pm

I do not think there is a simple way to do it. Just change it one by one, that will only take 2 days for one people.

chulett · Post by **chulett** » Mon Sep 24, 2007 10:21 pm

Ken Bland has a utility that will easily handle #1 and is part of what he gives away for free from his website.

Raghavendra · Post by **Raghavendra** » Tue Sep 25, 2007 1:18 am

we had same requirment for task2 ( removing default values of parameters). We have contacted IBM for the same and they gave a routine to do that particular task. That was in my previous organisation and i don't remember the routine name now.

Raghavendra · Post by **Raghavendra** » Tue Sep 25, 2007 1:19 am

we had same requirment for task2 ( removing default values of parameters). We have contacted IBM for the same and they gave a routine to do that particular task. That was in my previous organisation and i don't remember the routine name now.

jdmiceli · Post by **jdmiceli** » Wed Sep 26, 2007 4:36 pm

I wrote a Perl script that does this exact thing, but it is for Server jobs. Does anyone know if the DSX files for Parallel and Server are similar in structure? If so, then I can make the script available to you to use.

jdmiceli · Post by **jdmiceli** » Wed Sep 26, 2007 4:38 pm

I wrote a Perl script that does this exact thing, but it is for Server jobs. Does anyone know if the DSX files for Parallel and Server are similar in structure? If so, then I can make the script available to you to use.

chulett · Post by **chulett** » Thu Sep 27, 2007 10:58 pm

From an email question:

bkamila wrote:Hi Mr Chulett

Do you know the contact details or url of Ken Bland's utility? Please email me, if you know how to download the utility.

As noted earlier, from his website:

http://www.kennethbland.com/

You'll need to request a password first. Once you have access, you can download the KBA Job Control Utilities.

jdmiceli · Post by **jdmiceli** » Fri Sep 28, 2007 8:48 am

Hi all!

I have had several requests for my Perl script so I will start another thread in the General Section and post it. I will also include my other utilities just in case anyone can use them.

Bestest!

jdmiceli · Post by **jdmiceli** » Thu Oct 04, 2007 3:48 pm

This thread has multiple utilities to work with .dsx and other files (in Perl):

viewtopic.php?t=113429&highlight=perl

I hope it help!

Bestest,

Add new parameter and remove default value from Jobs

Add new parameter and remove default value from Jobs

Re: Add new parameter and remove default value from Jobs