Universal variable

[babbu9]

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.

[ogmios]

Not directly in DataStage, but since it's flexible you can find ways around it: store values in files, databases, hash files, ...

Ogmios

[ray.wurlod]

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.