Re: Triggers - enabling and disabling

Why didn't I think of suggesting that? Wait, I did.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Alan Campin <alan0307d@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 10/04/2012 11:00 AM
Subject: Re: Triggers - enabling and disabling
Sent by: midrange-l-bounces@xxxxxxxxxxxx



use my Trigger Mediator. Never put a trigger on a table directly
unless you want a nightmare.

On Thu, Oct 4, 2012 at 8:52 AM, <rob@xxxxxxxxx> wrote:

Data queue processing is probably the cleanest.


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: rob@xxxxxxxxx
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>,
Date: 10/04/2012 10:52 AM
Subject: Re: Triggers - enabling and disabling
Sent by: midrange-l-bounces@xxxxxxxxxxxx



keep your trigger program simple. It does nothing but call the next
program, passing the same parameters. Now, whether or not you have to
blow an activation group, or delete the program out of QRPLLIB, when you
put in a new version of your program in there is another issue. For
example
Trigger program is TRIGGER.
TRIGGER calls TRIGGER1 passing all the same parameters to TRIGGER1. Need
a change. Update TRIGGER1. Make sure that TRIGGER calls latest copy of
TRIGGER1 (and not one from QRPLLIB).

See also "Alan Campin - Trigger Mediator V2R1."
at
http://www.think400.dk/downloads.htm


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Åke Olsson <ake.olsson@xxxxxx>
To: " (midrange-l@xxxxxxxxxxxx)" <midrange-l@xxxxxxxxxxxx>,
Date: 10/04/2012 10:44 AM
Subject: Triggers - enabling and disabling
Sent by: midrange-l-bounces@xxxxxxxxxxxx



We have to set up triggering for a bunch of files (15 files in 30
instances). I can live with having to find a spot when the system is

down

to add the tiggers.

But we would like to turn on and off the activation of triggers more or
less at will. Status *ENABLED and *DISABLED should work nicely.

The problem is that this operation seems to require private access to

the

file almost as much as ADDPFTRG does - is that really so?

Is there in that case another better way to dynamically switch triggers

on

and off?


Med vänlig hälsning / Best regards

Åke H Olsson
[Description: cid:image001.png@01CA1FE6.387A03A0]
Box 433 SE 551 16 Jönköping Sweden visit: Brunnsgatan 11
phone: +46 (0)36 342976 mobile: +46 (0)705 482976 fax: +46 (0)36 34 29
29
ake.olsson@xxxxxx<mailto:ake.olsson@xxxxxx> www.pdb.se

--
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.

--
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.