?
Solved

How can i send email from stored procedure in db2

Posted on 2002-05-14
5
Medium Priority
?
534 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:prasoonkc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 7

Accepted Solution

by:
waynezhu earned 200 total points
ID: 7009059
Use UDF (user defined function). Take a look at this
article:
http://www.db2mag.com/db_area/archives/2000/q4/cutlip.shtml
0
 
LVL 1

Expert Comment

by:aaronkempf
ID: 7011159
now why would you move from one obsolete db to another???

0
 
LVL 1

Expert Comment

by:AAMFK
ID: 7234319
i was just kidding.. sorry..

0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question