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
 

 

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: 991
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: 10210
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: 10210
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 Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts INDEPENDENT CICS TS 4.1 MRO REGION UP... Kyle Carroll CICS 0 Wed Dec 14, 2016 6:55 pm
No new posts CICS START AND CANCEL blayek CICS 1 Wed Dec 07, 2016 3:27 am
No new posts I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm


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