Any way to put parameter?

[Mhasan]

HI,
Is there any automated way to take the paramter from the enviromental variable ... rather then manually entering for each job... if we have many number of source systems ... is there anyway (or routine who can serve the purpose)

[ray.wurlod]

No.

When you upgrade to version 8.0 you get a new construct called a "parameter set", which will make life easier.

But, until then, the answer is no.

[kduke]

I would put the parameter values in a text file. Read the text file in a loop. Feed the lines into your jobs one line at a time.

[chulett]

You might want to clear up exactly what your question is, you've gotten two responses from two different camps. Is this a design question - adding large numbers of parameters to jobs - or a runtime question?

[Mhasan]

Hi ,
Atucally My question was ....for example ..i have a job A for that i need to define the jobparameter value those are actually defined in Environmemtal variable as userdefined.....i can do this task machanically for each job ..Now my question is Is there any austomated methed to place these Parameter.

Chullete anser response was pretty clear there is no such method to put the parameter..May be it will available in 8x..


But Kduke response confused me little bit ..acording to him he put these parameter value via file ..If it can happen please let me know the process flow to put in.

[Yuan_Edward]

Set the value of the environment variables in your job to $PROJDEF, if the
value of the environment variable is subsequently changed (e.g. you can change the value in DS Administrator), the job will pick up the new value without the need for recompiling.

Not sure if this is what you are after.
=============================================
And also, i just realized that the values of environment variables can be overridden the same way as normal job parameters if the job is run from the command line using dsjob.

Hi ,
Atucally My question was ....for example ..i have a job A for that i need to define the jobparameter value those are actually defined in Environmemtal variable as userdefined.....i can do this task machanically for each job ..Now my question is Is there any austomated methed to place these Parameter.

Chullete anser response was pretty clear there is no such method to put the parameter..May be it will available in 8x..


But Kduke response confused me little bit ..acording to him he put these parameter value via file ..If it can happen please let me know the process flow to put in.

[Yuan_Edward]

Is a job parameter better than an environment variable for this case?

if we have many number of source systems ... is there anyway (or routine who can serve the purpose)

[Mhasan]

Hi Yuan.

Environmental level we are defining the parameter for each source system.
For each job anyway we need to defien the parameter value if we are not passing the hard coded value to it ..So i posted that query .

[ray.wurlod]

The developer must manually Add Environment Variable to the job parameters grid for each required parameter.

Create a job containing your "standard" set of parameters, and use it as a prototype, and/or create a Template from it. That way at least the manual effort is required only once.

If someone destroys your prototype, by omitting to Save As, the appropriate punishment is for them to create the replacement prototype, ideally by undoing their changes.