Parameter Set changes not updating the Jobs

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
MrBlack
Participant
Posts: 125
Joined: Wed Aug 08, 2012 8:57 am

Parameter Set changes not updating the Jobs

Post by MrBlack »

Has anyone else notice that if you have a job(s) that use a parameter set, that if a change is made in the parameter set, it is not reflected in the job?

The situation I'm running into is I delete a variable from my parameter set but my job still thinks the variable is there and asks for it when I run my job and of course fails. I've tried:
  • recompiling
    removing/adding the parameter set to the job
    closing my designer and reopening
    making a copy of the job
    and a combinations of all of the above
No matter what I do, my job thinks the variable is still there. I can see the variable in the job control source code. So what I've had to do is export the job, use notepad to remove the bad code and import the job.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What version of DataStage?
-craig

"You can never have too many knives" -- Logan Nine Fingers
MrBlack
Participant
Posts: 125
Joined: Wed Aug 08, 2012 8:57 am

Post by MrBlack »

Datastage 8.1 unfortunately

We're working on upgrading to 9.1 but that's still a couple of months away.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Others would have to confirm but from what I recall that was an issue in "older" 8.x versions that was subsequently corrected.
-craig

"You can never have too many knives" -- Logan Nine Fingers
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

That is definitely fixed in 8.7. Another way to fix it is to save the job without the parameter set, exit the client, come back in and load the parameter set back into the job. Its a real pain on the early releases of 8.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
Post Reply