Using stage variable value of one job

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
yatin.mittal
Participant
Posts: 20
Joined: Fri Oct 14, 2005 12:52 am

Using stage variable value of one job

Post by yatin.mittal »

Hi,

I am struck in a problem.
I am having two jobs.
In first job, I am assigning some value to a stage variable in transformer stage, which I want to access in my next job as job parameter.
Is it possible to do ?
If yes, please guide me.

Thanks,
Yatin Mittal
Accenture Services Pvt. Ltd.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

No, the stage variables are per process/stage only and are not accessible anywhere else.
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

there is a workaround though.
populate that value of the stage variable in a hash file along with a dummy key.
access that hashfile in your second job.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

USERSTATUS.
-craig

"You can never have too many knives" -- Logan Nine Fingers
samba
Premium Member
Premium Member
Posts: 62
Joined: Wed Dec 07, 2005 11:44 am

Post by samba »

Declare stage variable in job using 'UserStatus'
In Sequence go to particular job, and triggers assign the stage variable as parameter using Activity variable
samba
Post Reply