Set Parameters from file in Sequence

alla · Post by **alla** » Mon Jun 04, 2007 3:15 pm

I need to read two values from the file once and then pass these values as parameters to multiple jobs . I already implemented this task by writing Job Control code in the controlling job.
How this can be implemented using Sequence ?

Thanks for your help,

Alla

chulett · Post by **chulett** » Mon Jun 04, 2007 4:23 pm

Welcome. :D

Are you on a 7.5.x release of DataStage? If so, then you have the UserVariables Activity stage which can be used for this purpose.

kduke · Post by **kduke** » Mon Jun 04, 2007 11:27 pm

Your batch control code can be moved to a routine. This routine needs to return the value in one of its arguments. These argument values are available to use as parameter values.

alla · Post by **alla** » Fri Jun 08, 2007 3:09 pm

I created a Function routine with two output arguments.
These arguments can be accessed in the subsequent activities
in the Sequence.

Thank you for your help.