DB2 how to send an email from Stored Procedure?

Question

Team,

I have scenerio where in i need to send an email from my stored procedure in DB2.

However i have not been able to figure out any so far, apart from using Task Center or Query Patroller. Can any one suggest me some pointers to this? I do not want to do it from any other language though.

Thanks, Harveer

Answer 1

There is nothing built-in in DB2 to do that, like xp_sendmail in SQL Server.

You have to write your stored procedure in one of the hosted languages (Java, C++) and then use an API from that language to send the mail.

See this article on how to do it using Java.

Answer 2

With 9.7, you can use the UTL_MAIL or UTL_SMTP built-in packages.