How to Set Variables in DataStage?

sasikiran · Post by **sasikiran** » Fri Nov 17, 2006 1:09 am

Hi All,

I have a requirement like I have to set the variable based on output of the some logic, how to do this?

In Detail:

I have a table, from that table I have to fetch the value of one column based on date and state, I have to store this value in one variable which I will use further in my jobs. Please help me out on this.

Thanks in Advance

Thanks for Reply

kduke · Post by **kduke** » Fri Nov 17, 2006 6:37 am

I land the values in a hashed file. I use the utility hash read routine to read it into a variable in a sequence to load it into a parameter.

balajisr · Post by **balajisr** » Fri Nov 17, 2006 6:55 am

You can also set the value into job's userstatus and read the value in job sequence.

DSguru2B · Post by **DSguru2B** » Fri Nov 17, 2006 7:04 am

As Kim suggested, do your select and load it into a hashed file with a dummy key. Then read that value where ever you want, in the transformer or set it as a default value of a parameter etc.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 17, 2006 7:43 am

A User Variables activity in a job sequence allows each variable to be set based on an expression.

A stage variable in a Transformer stage similarly allows initialization using an expression. If this variable needs to remain unchanged for each row processed, leave its Derivation field empty.

Where is your variable?