View previous topic :: View next topic
|
Author |
Message |
rathinakarthik
New User
Joined: 25 Jul 2006 Posts: 24
|
|
|
|
Hi,
I need to send a Notification a Particular row is inserted in DB2 Tables. I found DB2 triggers as an option.
Could you please guide me how to send notification as an event of DB2 Trigger.
The Notification can be any of the Following
Via E-mail or
Notification in MQ or
Starting of a Program which will send the notification
Thank you |
|
Back to top |
|
|
Bill Dennis
Active Member
Joined: 17 Aug 2007 Posts: 562 Location: Iowa, USA
|
|
|
|
We typically insert a row into another table using a trigger. Then a process reads the rows in the second table to take action.
I don't think you're going to take any your desired actions directly with a trigger. |
|
Back to top |
|
|
Prajesh_v_p
Active User
Joined: 24 May 2006 Posts: 133 Location: India
|
|
|
|
Trigger can be set up to do only database operations like insert, update etc. So I feel that u should have process coupled with table insert application to send the noticication or else u should have a batch application on an interval to read all messages inserted and send the notifications appropriatly.
Plz correct me if I am wrong.
Thanks,
Prajesh |
|
Back to top |
|
|
|