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
How to Set Variables in DataStage?
Moderators: chulett, rschirm, roy
How to Set Variables in DataStage?
SasiKiran
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
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?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.