Setting job parameter after importing a .dsx

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
stefania.dp
Participant
Posts: 1
Joined: Fri May 21, 2010 6:52 am

Setting job parameter after importing a .dsx

Post 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
vinnz
Participant
Posts: 92
Joined: Tue Feb 17, 2004 9:23 pm

Post 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
priyadarshikunal
Premium Member
Premium Member
Posts: 1735
Joined: Thu Mar 01, 2007 5:44 am
Location: Troy, MI

Post by priyadarshikunal »

I think someone earlier posted a perl script to do similar task, search for it.
Priyadarshi Kunal

Genius may have its limitations, but stupidity is not thus handicapped. :wink:
Post Reply