Page 1 of 1

Setting job parameter after importing a .dsx

Posted: Fri May 21, 2010 8:10 am
by stefania.dp
Hi,
I'm configuration manager for the DWH in Integration environment. At each canvass I have to refresh the integration environment importing the entire Production DataStage Project. After importing, I need to replace the production default value of job parameter with the corresponding integration value (e. g. for all parameters related to the source or target DB; currently I have more then 700 server job and each job contains about 15 parameters).
There is a faster procedure to do this?
The standard procedure is to insert the new value in the Parameters tab of the Job Properties popup; there is any alternate solution?

Thanks and regards
Stefania

Posted: Fri May 21, 2010 12:24 pm
by vinnz
You could use your favorite Search/Replace utility to change the parameter values in the dsx file before you import into your Integration Environment

Posted: Mon May 24, 2010 3:06 am
by priyadarshikunal
I think someone earlier posted a perl script to do similar task, search for it.