Re: Can I use a trigger to...

["Raul A. Jager W." <raul@xxxxxxxxxx>]

Yes, Triggers will do the job,

GKern@xxxxxxxxxxxxxxxx wrote:

> Last night, being month end, we started our month end process at 6:00 pm.
>
> Unfortunately, one person, in another time zone entered some transactions 
> that were dated for 9/30 but were not included in the month end process 
> because her work was done after month end had finished.
>
> Now the first offered solutions was to disable the subsystem, lock users 
> out, allocate objects etc... which due to limited manpower and some 
> political logistics is impractical.
>
> So I wondered if there is a way to use a before event trigger (before 
> add/update/delete) to detect if record maintenance was requested during a 
> specific time period. I know that the trigger can detect the activity but 
> is there a way to prevent the actual add, update or delete operation from 
> occurring?
>
> In looking at the ADDPFTRG command I didn't see any parms that might 
> address this. 
>
> I use the trigger template program from an article Jon and Susan did 
> awhile back (eserver iSeries edition January 2002). 
>
> In that code, could I simply overlay the new buffer with the old buffer 
> contents - effectively preventing an update?
>
> But just as important, how would I prevent an add or delete?
>
> Is this possible or are there other solutions?
>
> Thanks!
>
> Regards, Jerry
>
> Gerald Kern - Information Technology 
> Programming Supervisor
> IBM Certified RPG IV Developer
> Lotus Notes/Domino 8.0.1 Administrator
> The Toledo Clinic, Inc.
> 4235 Secor Road
> Toledo, OH 43623
> Phone 419-479-5535
> gkern@xxxxxxxxxxxxxxxx
>
>
> This e-mail message, including any attachments, is for the sole use of the 
> intended recipient(s) and may contain confidential and privileged 
> information. Any unauthorized use, disclosure or distribution is 
> prohibited. If you are not the intended recipient, please inform the 
> sender by reply e-mail and destroy this and all copies of this message.
>