MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 2014

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



fixed


I don't see anything in the OVRDBF that restricts EOFDLY
to physical files...but I have never tried it myself.

Terry


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

Terry,
I like your idea.
Can I use EOFDLY for a logical file?
If so, I can have a small program running in the background
that issues a
read against this file and then preforms the update.

Jeff Young
Sr. Programmer Analyst


On Fri, May 30, 2014 at 11:30 AM, Winchester Terry <
terry.winchester@xxxxxxxxxxxxxxx> wrote:


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.



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








Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact