A new requirement is to send emails to different persons according to the records in one table updated by other application.
suppose the table has only 3 fields:receiver,content,issent
we need to query all the record with issent 'N' and send email for each record
the receiver is in column 'receiver' and content in 'content' ,after sending the email , issent should be set to 'Y'
Any ideas how to implement this?
Sending email per records
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you really think this is a suitable job for an ETL tool?
Surely the email server itself can be scripted to perform this task.
That said, yes it is possible with DataStage, probably easiest using a sequence job.
Surely the email server itself can be scripted to perform this task.
That said, yes it is possible with DataStage, probably easiest using a sequence job.
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.
This type of work is often done, where a table is read into a job sequence to iterate one call per row - here each call would be to a mail stage rather than calling a job.
The simplest method is to have the sequence call a server job, which executes the SELECT and puts the collected result into the user status. This is then used in the calling sequence as the basis for a loop.
It is not a particularly clean solution, but is frequently used.
The simplest method is to have the sequence call a server job, which executes the SELECT and puts the collected result into the user status. This is then used in the calling sequence as the basis for a loop.
It is not a particularly clean solution, but is frequently used.