Re: Trigger - Change New Offset Data

[Charles Wilt <charles.wilt@xxxxxxxxx>]

You may be thinking of "Allow repeated change" (ALWREPCHG) parm of the
ADDPFTRG command...

That allows a before trigger to update the row.

Only needed for external triggers.  SQL triggers have it set by default.


Charles

On Fri, Nov 3, 2017 at 8:23 AM, (WalzCraft) Jerry Forss <
JForss@xxxxxxxxxxxxx> wrote:

> Hi All,
>
> I have been using RPG triggers to sync other files. Works great.
>
> When a user enters/updates a customer address (using vendor maintenance
> screens) I want to scrub the data using Works Right address verification.
>
> On a Before Update trigger I would take new data, scrub it and change the
> data stream so when it updates it uses the new corrected data.
>
> I seem to remember there was something "special" I needed to do that
> allows me to change the data stream.
>
> Am I mis-remembering or is that correct?
>
> I can't change the vendor pgms and scrub it there so I have to deal with
> it downstream.
>
> Jerry Forss
> Information Technology Team
> WalzCraft
> 608-781-6355 EXT 2530
> jforss@xxxxxxxxxxxxx
>
>
> Subject to Change Notice:
>
> WalzCraft reserves the right to improve designs, and to change
> specifications without notice.
>
> Confidentiality Notice:
>
> This message and any attachments may contain confidential and privileged
> information that is protected by law. The information contained herein is
> transmitted for the sole use of the intended recipient(s) and should "only"
> pertain to "WalzCraft" company matters. If you are not the intended
> recipient or designated agent of the recipient of such information, you are
> hereby notified that any use, dissemination, copying or retention of this
> email or the information contained herein is strictly prohibited and may
> subject you to penalties under federal and/or state law. If you received
> this email in error, please notify the sender immediately and permanently
> delete this email. Thank You;
>
> WalzCraft PO Box 1748 La Crosse, WI. 54602-1748
>
> www.walzcraft.com<http://www.walzcraft.com/> Phone... 800-237-1326
> --
> 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