How to assign a output column to an Environmental variable a

[Vignesh Shanmugam]

Hi all,

I have requirement in which.I have to assign the output count of a query to a variable and have the same included in the Body of Email notification stage.

(E.g).

1).select count(*) as COUNT from xxxx

2).This Output "COUNT" has to be assigned to some variable say "ENV_Variable"

3).This "ENV_Variable" has to be assigned to the Email body of Email notification.

How can this be achieved.Please give your inputs on this.

Thanks In advance.

[ray.wurlod]

I don't think this is possible using DataStage, but it would indeed be possible using a script.