RE: Update a field in a file from the trigger on the same file

Another thought: Create a select/omit logical that would limit
the view to negative values and then have a background process
come alive every few minutes to zero them out...


Terry

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On
Behalf Of Luis Rodriguez
Sent: Friday, May 30, 2014 11:28 AM
To: Midrange Systems Technical Discussion
Subject: Re: Update a field in a file from the trigger on the
same file

Jeff,

I would ask myself if this condition (the field becoming
negative) happens
very often. If it does not, maybe the best in performance
terms would be
isolating the programs that allow this condition to happen
and change them
accordingly.

On the other hand, a trigger such as the one you need is very
simple, and
perhaps it would not have much impact in performance terms
and (maybe) it
could be a better solution, depending to your business's needs.

HTH,
Luis


Luis Rodriguez
IBM Certified Systems Expert - eServer i5 iSeries
--



On Fri, May 30, 2014 at 10:45 AM, Jeff Young
<jyoung0950@xxxxxxxxx> wrote:

All,
I have a file that I want to monitor for a change to a

specific field.

If this field becomes negative, I want to set it to zero.

The file is updated by many programs and is my inventory

master, so there

are a large number of transactions all day.

Is a trigger the best way to do this?
If not, what would be the best method with the least impact

on performance?

If so, what is the impact on performance?


The system is at release V7R1M0 L00 TL12115


Jeff Young
Sr. Programmer Analyst
--
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.

--
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.

Confidentiality Notice:

The preceding e-mail message (including any attachments) contains information that may be confidential, protected by applicable legal privileges, or constitute non-public information. It is intended to be conveyed only to the designated recipient(s). If you are not an intended recipient of this message, please notify the sender by replying to this message and then delete it from your system. Use, dissemination, distribution or reproduction of this message by unintended recipients is
not authorized and may be unlawful.