Re: Trigger-happy

This simple solution looks very promising.

I'm wondering a couple of things though:

- Is the Delete Code used by your program to identify triggers no longer
used or active?
- If the generic trigger program is going to call different programs for
different events/times should they be included in the index on the file (
are they on another index or do I misunderstand? )
- Is the UISOURCE something specific to your system?

thanks,
Craig

On 27 February 2018 at 13:40, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Is this a place for a procedure pointer? And would the pointer be
different if the program is changed, or would it always point to what was
found the first time?


On 2/27/2018 7:31 AM, Craig Richards wrote:

Thanks all for replying - that was very instructive.

I've only had a chance for a quick look for now but I appreciate your
links
and sharing and I'll make time to investigate further.

Kevin, I like the simplicity of this approach and I can see the ease with
which things can be switched on and off.

I'm assuming that because you have both the program name and program
library in your file, that the program is called through a variable.

And if you are calling a program via a variable, if I remember correctly
it
will resolve it every time?

If my memory and assumptions are correct that tells me that you could
actually change the called program ( the one in the file ) and get
currently active jobs to recognise it immediately rather than them working
with a QRPLOBJ version until they sign off.
Can you confirm this?

thanks kindly,
Craig

On 27 February 2018 at 13:07, Kevin Bucknum <Kevin@xxxxxxxxxxxxxxxxxxx>
wrote:

All of our files that have triggers get the same program as the trigger.

When the trigger fires, we take the file, library, event type, and time,
and go out to a file. If there is an active entry, we call the program
and
pass along the buffer that is needed. You can have multiple entries and
call multiple trigger handlers as needed. Not as sophisticated as Alan
Campin's program, but it has worked well for us over the years. The file
looks like this:
Key Field Length Dec Type From To Text
TGDLCD 1 A 1 1 DELETE CODE
K2 TGFNM 10 A 2 11 FILE NAME
K1 TGFLIB 10 A 12 21 FILE LIBRARY
K3 TGSQ 5 0 P 22 24 TRIGGER SEQUENCE
TGDESC 50 A 25 74 DESCRIPTION
TGPNM 10 A 75 84 PROGRAM NAME
TGPLIB 10 A 85 94 PROGRAM LIBRARY
TGTIME 1 A 95 95 TRIGGER TIME
TGEVNT 1 A 96 96 TRIGGER EVENT
UISOURCE 1 A 97 97 ENTRY SOURCE


Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----Original Message-----

From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Craig Richards
Sent: Monday, February 26, 2018 4:38 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Trigger-happy

One technique I’ve seen for triggers is to have the actual trigger

program do

nothing more than forward the trigger buffer data on to another program.

That way the logic can be changed without having to remove the trigger
program from the file which requires exclusive access.

( I know this doesn’t solve the issue of currently running jobs

continuing to

access the old object )

One part of my application won’t like this but I could resolve my

particular

problem by putting the program in the same library as the file ( which

IBM

recommend anyway ) but I’d be interested to find out if anyone else uses
this as a general approach?

Thanks,
Craig
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To

subscribe,

unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD