Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Notification using DB2 Triggers

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Notification using DB2 Triggers
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 triggers to send realtime data rz061m DB2 2 Sat Jul 11, 2015 8:43 am
No new posts Email on Mainframe notification erdilverma IDMS/ADSO 2 Wed May 30, 2012 12:58 am
No new posts Job triggers to run one after the other Nic Clouston JCL & VSAM 9 Thu Oct 20, 2011 6:06 pm
No new posts Prevent Notification on Cancelling a Job enrico-sorichetti JCL & VSAM 6 Fri Oct 07, 2011 2:19 am
No new posts IMSDC screen abends and triggers mail abdulrafi IMS DB/DC 2 Tue May 31, 2011 6:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us