To Fetch Stage Variable Output

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
venkatesan
Premium Member
Premium Member
Posts: 10
Joined: Sat Dec 25, 2010 11:35 pm
Location: Bangalore
Contact:

To Fetch Stage Variable Output

Post by venkatesan »

All,

Can you please let me know how to pass the stage variable output to UserVariables Activity stage.

--
Thanks,
Surya
samyamkrishna
Premium Member
Premium Member
Posts: 258
Joined: Tue Jul 04, 2006 10:35 pm
Location: Toronto

Re: To Fetch Stage Variable Output

Post by samyamkrishna »

you can probably put all the values in a file and use that file in user variable activity.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What you request is impossible as a direct pass. Stage variables occur wholly within Transformer stages in parallel or server jobs. User Variables activities occur in sequence jobs. The one can never occur in the other.

The most direct would be to load the job's user status area with the value of the required stage variable. However, only the stage variable value for the final row will ever be accessible once the Transformer stage closes.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply