How do I use the sendmail within a transformer

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
pandi23
Participant
Posts: 4
Joined: Fri Apr 23, 2004 2:20 pm

How do I use the sendmail within a transformer

Post by pandi23 »

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
kiran_kom
Participant
Posts: 29
Joined: Mon Jan 12, 2004 10:51 pm

Post by kiran_kom »

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 :-)
Post Reply