Hi
Is there a possibility to store a variable, lets say select count(*) from table value such that it is accessible from any job downstream in the sequence from where this variable is defined. If so how?
I am trying to store record count value from a oracle database and use that value later in the sequence.
Please inform.
Thanks.
Universal variable
Moderators: chulett, rschirm, roy
Re: Universal variable
Not directly in DataStage, but since it's flexible you can find ways around it: store values in files, databases, hash files, ...
Ogmios
Ogmios
In theory there's no difference between theory and practice. In practice there is.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Easiest and most efficient is to "store" it in a column being propagated in the data stream being processed. This remains available as far downstream as you could wish, until you discard it.
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.