How can i send email from stored procedure in db2

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.
prasoonkcAsked:
Who is Participating?
 
waynezhuCommented:
Use UDF (user defined function). Take a look at this
article:
http://www.db2mag.com/db_area/archives/2000/q4/cutlip.shtml
0
 
aaronkempfCommented:
now why would you move from one obsolete db to another???

0
 
AAMFKCommented:
i was just kidding.. sorry..

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.