Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Trigger a CICS Program via DB2 trigger

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
thunderstorm

New User


Joined: 23 Mar 2007
Posts: 35
Location: pune

PostPosted: Fri Jul 29, 2011 5:16 am    Post subject: Trigger a CICS Program via DB2 trigger
Reply with quote

Dear All,

I have a requirement to execute a CICS program whenever an inserts happen in a DB2 table. Can you provide some insights as to whether its possible or not ? If possible, what steps needs to be done ? For example, we have to define the DB2 trigger , then define the CICS PCT,PPT entries.

Eagerly waiting for replies
Thanks !
Thunder~storm
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: Fri Jul 29, 2011 6:19 am    Post subject:
Reply with quote

Hello,

Why does someone believe this is a "requirement" . . . icon_confused.gif

A more proper approach would be to make the needed code external to cics.

This sounds more like someone trying to be clever than actually address a business requirement.

What business function will this code provide/support?
Back to top
View user's profile Send private message
Garry Carroll

Active Member


Joined: 08 May 2006
Posts: 998
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Fri Jul 29, 2011 12:15 pm    Post subject:
Reply with quote

Would this DB2 insert be a CICS "event" ??

Garry
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Fri Jul 29, 2011 7:11 pm    Post subject: Reply to: Trigger a CICS Program via DB2 trigger
Reply with quote

why not look Yourself at the db2 manuals to find out what are the events that can be scheduled by triggers
for db2 9.1 here is the link to the mother of knowledge for DB2
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/DSNSHKA3

to save You some searching time here is the direct link to the relevant manual
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPK13/CCONTENTS?SHELF=DSNSHKA3&DN=SC18-9841-03&DT=20081114012927

or to save You more searching time here is the link for just the basics of triggers
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnapk13/2.3.8?SHELF=DSNSHKA3.bks&DT=20081114012927
Back to top
View user's profile Send private message
thunderstorm

New User


Joined: 23 Mar 2007
Posts: 35
Location: pune

PostPosted: Sat Jul 30, 2011 4:24 am    Post subject: Reply to: Trigger a CICS Program via DB2 trigger
Reply with quote

Gary - That's correct. I am expecting the CICS txn to get trigerred with every insert within the table. Obviously , The number of inserts into the table will be very rare. But we want to get notified immediately whenever any insert happens.
Back to top
View user's profile Send private message
thunderstorm

New User


Joined: 23 Mar 2007
Posts: 35
Location: pune

PostPosted: Sat Jul 30, 2011 4:32 am    Post subject:
Reply with quote

The trigger documents do not show that any program can be trigerred or any JCL can be run..So, Is it true that we can do only DB2 activities like insert or delete within the trigger ?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Sat Jul 30, 2011 5:20 pm    Post subject: Reply to: Trigger a CICS Program via DB2 trigger
Reply with quote

yep!
but since You can also call a stored procedure,
the answer is delayed by one jump icon_biggrin.gif
what can You do inside a stored procedure ???

but Your wise db2 support group shoud be aware of
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dsnapk13/2.7.9?ACTION=MATCHES&REQUEST=dsnacics&TYPE=FUZZY&SHELF=DSNSHKA3.bks&DT=20081114012927&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

the only puzzling comment is
Quote:
DSNACICS gives workstation applications

but then there is a sample invocation of dsnacics from a pli program
Your support will have to carry on a bit of investigations
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us