RE: Two trigger programs allowed on a file. Maybe more allowed?

Eric,

From the generic V7R1 screen, try this:

1) type "maximum file triggers" in the "Search:" box
2) when the search results are displayed:

select "Add Physical File Trigger (ADDPFTRG)" from the column on your left

Look at the third paragraph in the window on your right.

Enjoy

And consider a possible commuted sentence for "the person in charge" ;)


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Raymond B. Dunn
Sent: Monday, May 20, 2013 8:26 AM
To: Midrange Systems Technical Discussion
Subject: 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.