I even tried to search for maximum number of triggers in the DB2 manual.
Nothing.
Sure????
SQL Reference --> Create Trigger --> Notes --> Multiple Triggers (Page 989):
A maximum of 300 triggers can be added to any given source table.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Raymond B. Dunn
Gesendet: Monday, 20.5 2013 16:26
An: Midrange Systems Technical Discussion
Betreff: RE: Two trigger programs allowed on a file. Maybe more allowed?
Really? It took me to a generic V7R1 screen. I even tried to search for
maximum number of triggers in the DB2 manual. Nothing.
Again, this is an example of how IBM has made the manuals absolutely
worthless. I would love to take the person in charge of the V7R1 manuals
and beat him/her within an inch of their life.
I can remember back when the manuals were an asset. Thank god for the
internet and non-IBM information resources.
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Monday, May 20, 2013 8:52 AM
To: Midrange Systems Technical Discussion
Subject: RE: Two trigger programs allowed on a file. Maybe more allowed?
Eric,
This link shows a max of 300
http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/index.jsp
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Eric Lehti
Sent: Monday, May 20, 2013 7:45 AM
To: Midrange Systems Technical Discussion
Subject: Two trigger programs allowed on a file. Maybe more allowed?
I succeeded in attaching a second trigger program to a file yesterday.
Happy. I did not realize that system will allow more than one trigger
program.
I did not want to modify the existing (first) program trigger that tracks
sales order totals in real-time.
I created second trigger program with JD Edwards DBAM (data base audit
manager) to identify which process is changing info in one field.
How many trigger programs will system allow on a file? I will find out
someday.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
