How can i send email from stored procedure in db2

[prasoonkc]

Hi I am on a project where we have to migrate database from oracle to db2. There is a java stored procedure written for oracle that sends email to the users after picking up their email id from database. It uses java mail api to send the mail. I have been trying to port the java stored procedure from oracle to db2 but I am not able to set the jar files of javamail on db2 from where the java stored procedure can pick up the classes. I would like to know if there is any way to set to jar packages from where the java stored procedure can pick up the classes. If that i not possible i would like to know how to send mail from normal stored procedure.

 

[MarcLodge]

Prasoonkc,
There's an article entitled 'Using the Web, DB2, Java, JDBC, and the JavaMail API to manage bulk e-mail lists' that allegedly 'explains, with code samples, a fully working Java-based e-mailing application that allows you to manage a mailing list over the Web'. It appears to do what you are talking about, using DB2, not Oracle. I have no experience of it, but hope this helps.....

http://www-106.ibm.com/developerworks/ibm/library/i-email2/

Marc

 

[blom0344]

Hello Prasoonkc,

Actually I have no answer to your question, just another question based on the fact that you mention stored procedures on DB2. Do you possibly have examples of using stored procedures (SQL,Java) that trigger the dropping / rebuilding of indexes on tables. Or do you know where to search for them.

Thanks in advance,

blom0344