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
 

 

Email-trigger from IMSDC screen.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
abdulrafi

Active User


Joined: 14 Sep 2009
Posts: 135
Location: Coimbatore

PostPosted: Sat May 14, 2011 1:02 am    Post subject: Email-trigger from IMSDC screen.
Reply with quote

Hi,

I have a requirement like,
I do have an IMS screen from where user entries are stored into a DB2 table.
Now I need to send an e-mail notification to the user if something has been done on the screen which affects the DB2 table entries ie) if it is updated inserted or deleted.
I can do this in batch process but I would like to know if there is a way in online to identify whenever an user has changed some info on the IMS screen which in turn affects the DB2 table so that with that identification I can send him email spontaneously.

Please do let me know if there is a way.
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 1712
Location: UK

PostPosted: Sat May 14, 2011 10:07 am    Post subject:
Reply with quote

Why not just send a message back to the terminal?
Back to top
View user's profile Send private message
abdulrafi

Active User


Joined: 14 Sep 2009
Posts: 135
Location: Coimbatore

PostPosted: Mon May 30, 2011 3:59 pm    Post subject: Reply to: Email-trigger from IMSDC screen.
Reply with quote

I cant do that because my requirement is to send an-email to receipients when a particular transaction happens in IMSDC online system.
Back to top
View user's profile Send private message
abdulrafi

Active User


Joined: 14 Sep 2009
Posts: 135
Location: Coimbatore

PostPosted: Mon May 30, 2011 5:43 pm    Post subject:
Reply with quote

I would just need to know if i can trigger a batch job from a IMS DC program in order to send the e-mails. I knew its possible in CICS but i am trying to find out if i can do it with IMSDC.

Plz help me out if anybody has some idea on it.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Mon May 30, 2011 9:35 pm    Post subject:
Reply with quote

One way is to have the MPP issue a DB2 stored procedure call. IBM provides a sample DB2 stored procedure that can submit jobs.
Back to top
View user's profile Send private message
abdulrafi

Active User


Joined: 14 Sep 2009
Posts: 135
Location: Coimbatore

PostPosted: Tue May 31, 2011 2:01 pm    Post subject:
Reply with quote

Oh is it. Could you please let me know how it can be used. ?.
if you have material kind of do pass it on.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Tue May 31, 2011 5:42 pm    Post subject:
Reply with quote

Google is your friend.

Hint: SP name is DSNACCJS
Back to top
View user's profile Send private message
itssreehere
Warnings : 1

New User


Joined: 10 Jan 2006
Posts: 65
Location: chennai

PostPosted: Tue Jun 28, 2011 2:15 pm    Post subject:
Reply with quote

In Db2 you can create triggers. "A trigger defines a set of actions executed executed in response to the event of an INSERT, UPDATE or DELETE operation on a specified table. When such an SQL operation is executed, the trigger is said to be activated. The trigger can be activated before the SQL operation or after it".

Refer-http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/c0007038.htm

This way you can define a trigger and decide what to do when the table is updated.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jun 28, 2011 7:43 pm    Post subject: Reply to: Email-trigger from IMSDC screen.
Reply with quote

Hello,

Why have you posted db2 trigger info when the question is about ims . . . icon_confused.gif

d
Back to top
View user's profile Send private message
itssreehere
Warnings : 1

New User


Joined: 10 Jan 2006
Posts: 65
Location: chennai

PostPosted: Wed Jun 29, 2011 12:58 pm    Post subject: Reply to: Email-trigger from IMSDC screen.
Reply with quote

Question is about an an IMS DC screen which insert/delete/update data in a DB2 table. And he wants to send the email whenever a modification happens to the DB2 table. I just suggested one of the easy ways to achieve the result.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Jun 29, 2011 8:04 pm    Post subject: Reply to: Email-trigger from IMSDC screen.
Reply with quote

OK. My understanding was a bit different, but i believe i like yours better icon_smile.gif

d
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 641
Location: Whitby, ON, Canada

PostPosted: Wed Jun 29, 2011 9:01 pm    Post subject:
Reply with quote

I think you can also use the IMS Spooler API to send email, but I have never done it and can offer no advice.
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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts IMS DC screen Access sivasaras IMS DB/DC 3 Fri Nov 18, 2016 6:38 pm
No new posts Reading data from PS file and send it... rajatbagga All Other Mainframe Topics 18 Fri Sep 23, 2016 12:51 pm
No new posts Increase the screen size after split mistah kurtz TSO/ISPF 2 Fri Sep 02, 2016 6:39 pm
No new posts Automation of data entry using Rexx i... zingy.rajeev CLIST & REXX 4 Mon Aug 22, 2016 4:13 pm
This topic is locked: you cannot edit posts or make replies. Automation of data entry using Rexx i... zingy.rajeev CICS 0 Mon Aug 22, 2016 4:11 pm


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