Sequencer Design

amsh76 · Post by **amsh76** » Sun May 23, 2004 6:38 pm

How to insert parameters automatically for the jobs, in sequncer. Here I dont want to enter parameters manually, it should happen automatically.
So do i have to design a job with that stores parameters in file ?

ray.wurlod · Post by **ray.wurlod** » Sun May 23, 2004 7:33 pm

The sequence itself is a job and has parameters. Fill these in in the usual way, in the Parameters grid.
Then, when you're loading parameters in a Job Activity, choose Insert Parameter to select the sequence's parameter reference.
There is no "select all" for this functionality. If you can make a business case, log an enhancement request with Ascential.

vmcburney · Post by **vmcburney** » Sun May 23, 2004 7:54 pm

It is a pain having to put the job parameters into sequence job stages each time, they really do need an automap or automatch button as frequently the sequence job parameters have the same name as the server jobs being called. One short cut is to upgrade to version 7.x and use the cut and paste. That way you set up the job parameters for just one server job and you can endlessly copy and paste that stage and change the job name leaving job paramters intact.

ray.wurlod · Post by **ray.wurlod** » Sun May 23, 2004 9:11 pm

Check out Parameter Manager for DataStage. This gives you the ability to store global parameters and bulk load them into jobs and sequences when and where you will.

tonystark622 · Post by **tonystark622** » Tue May 25, 2004 7:20 am

I wrote a routine that retrieves a parameter value from a file given the filename and parameter name. I add a routine stage to the Job Sequence job for each parameter that needs to be retrieved and set the parameter in the Job Activity stage to the return value of the appropriate routine stage. It's a little bulky to have a bunch of routine stages at the beginning of each sequencer job, but it seems to work well enough.

Tony