Silly parameter question

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
johnno
Participant
Posts: 50
Joined: Wed Mar 05, 2003 5:33 am

Silly parameter question

Post by johnno »

DataStage version 6 on Windows 2000.

Is it possible to populate job/sequence parameters from a stage variable or value from an input row? If so, how would you go about it?

I know it sounds simple, but I can't get anything to work.

Cheers
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
well depending on what you want to do you can do one of the following:
1. use a job to return userstatus and use that value as a parameter for the next job activity stage in a sequence job or somethign similar with batch jobs.
2. output the variable info to files and read them in batch job to get the parameter values you need.

Hope This Helps,


Roy R.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

If you're in the controlling job, you can obtain the values of the controlling job's parameter values using DSGetParamInfo function. You can then use DSSetParam to set parameter values for a controlled job, before starting that controlled job's run.
There is no sensible way to obtain a value from a stage variable and use that to update a parameter value, because job parameter values can not be changed once the job is running.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
Post Reply