Assign Value to Parameter within Job

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
cp2098
Premium Member
Premium Member
Posts: 8
Joined: Tue Nov 16, 2010 10:57 am

Assign Value to Parameter within Job

Post by cp2098 »

Version: DataStage Parrallel 8.1

Issue: I'm trying to build a set of parallel jobs that depends on the previous parallel jobs execution and result set. I am having trouble figuring out how to capture a single row/column result set and store it in a variable that is shared across the current executing job. Can I assign a value to a parameter within a parallel job?

Thanks!
Chris
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Nope.
-craig

"You can never have too many knives" -- Logan Nine Fingers
cp2098
Premium Member
Premium Member
Posts: 8
Joined: Tue Nov 16, 2010 10:57 am

Post by cp2098 »

Thanks Craig! Is there a way within DataStage to share a value across subsequent jobs?

I know I write the value to a file but this job will be executed currently by others and the "ID" retunred will be specific to that job.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

The only way to "share" like that is to pass the value as a job parameter to all of the jobs. If this job is being run concurrently then it must be a multi-instance job and if that's the case you should be able to include the Invocation ID as part of the filename so there's no collision.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply