DSXchange

Can someone help with this.
I am new to datastage so this may be very simple to most.

issue: I have to send mail notification based on a count from oracle table.
I have the count coming into a transformer. can i use the sendmail within if-then in transformer derivation to send email. if so, should i have a output ( like a seq file )from the transformer for this to work. Any response is welcome for this beginner.

Thanks,
Karl

Datastage provides a "command stage" which lets you invoke an OS command. Issue the sendmail command when your criteria is met.

I dont recall exactly how you invoke sendmail, but im pretty sure you can figure it out yourself