|
View previous topic :: View next topic
|
| Author |
Message |
abdulrafi
Active User
Joined: 14 Sep 2009
Posts: 184
Location: Coimbatore
|
|
|
|
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 |
|
 |
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK
|
|
|
|
| Why not just send a message back to the terminal? |
|
| Back to top |
|
|
abdulrafi
Active User
Joined: 14 Sep 2009
Posts: 184
Location: Coimbatore
|
|
|
|
| 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 |
|
|
abdulrafi
Active User
Joined: 14 Sep 2009
Posts: 184
Location: Coimbatore
|
|
|
|
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 |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
| 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 |
|
|
abdulrafi
Active User
Joined: 14 Sep 2009
Posts: 184
Location: Coimbatore
|
|
|
|
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 |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
Google is your friend.
Hint: SP name is DSNACCJS |
|
| Back to top |
|
|
itssreehere
Warnings : 1
New User
Joined: 10 Jan 2006
Posts: 65
Location: chennai
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
Hello,
Why have you posted db2 trigger info when the question is about ims . . . 
d |
|
| Back to top |
|
|
itssreehere
Warnings : 1
New User
Joined: 10 Jan 2006
Posts: 65
Location: chennai
|
|
|
|
| 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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19243
Location: Inside the Matrix
|
|
|
|
OK. My understanding was a bit different, but i believe i like yours better 
d |
|
| Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010
Posts: 765
Location: Whitby, ON, Canada
|
|
|
|
| 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 |
|
|
|
|
