RE: FILE TRIGGER

Åke;

Just know that doing this defeats IBMs purpose of requiring an exclusive lock on the file to change a trigger. This requirement guarantees that you will have only one version of the trigger running in the system at one time.

Calling a program is probably 99.999% safe but calling a procedure is much less so.

Alan Comptin has what he calls a "trigger mediator" (which you can find in the archives) which he and others seem to have no problems with but in my environment I have been bitten using a mediator process so we do not allow them.

You have to assess the risk/benefit for your environment. One of the benefits we have found, not using a mediator, is that a more through test/validation of the trigger occurs before it is put into production. No one wants to kick a bunch of users off the system to fix an obvious mistake in a trigger.

Duane Christen

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Åke Olsson
Sent: Friday, December 03, 2010 6:18 AM
To: 'rpg400-l@xxxxxxxxxxxx'
Subject: RE: FILE TRIGGER

Another thing that I have noticed is that it is very convenient to use a tiny CL program as the trigger program.

The CL only accepts the parameters and then calls the "real" RPG trigger programs with these passed as parms.

The reason for this is that while the file is open by any user the trigger program as defined in the file is locked and cannot be replaced.

By doing as described the processing of the actual trigger can be changed more freely. Neat if emergency changes are necessary.


Med vänlig hälsning / Best regards

Åke H Olsson

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    www.pdb.se


This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.