Re: Can I use a trigger to...

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Jerry,

All your trigger needs to do to prevent an update is throw an
exception message up the stack.

Charles


On Fri, Oct 1, 2010 at 2:35 PM,  <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.
> --
> 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.