Information from database in email

[sam93]

Hi all,

I have to send an email notification in case of successful completion of a batch. This email message needs to contain values from a row in a database table. How can I get this information from the table and include it in the email notification message?

Thanks.

 

[niloynibhochaudhury]

Sam,

I think u can write a small mapping at the end of the batch and which writes the records into a small file. Then in the e-mail attach that file and send.

Nils