IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Notification using DB2 Triggers


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rathinakarthik

New User


Joined: 25 Jul 2006
Posts: 24

PostPosted: Thu Mar 20, 2008 6:25 pm
Reply with quote

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
View user's profile Send private message
Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Thu Mar 20, 2008 6:46 pm
Reply with quote

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
View user's profile Send private message
Prajesh_v_p

Active User


Joined: 24 May 2006
Posts: 133
Location: India

PostPosted: Fri Mar 21, 2008 3:18 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Log an Plan name/id or Job Id using D... DB2 1
No new posts CICS web service from DB2 Triggers or... DB2 2
No new posts DB2 triggers to send realtime data DB2 2
No new posts Email on Mainframe notification IDMS/ADSO 2
No new posts Job triggers to run one after the other JCL & VSAM 9
Search our Forums:

Back to Top