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

[Gqcy <gmufasa01@xxxxxxxxx>]

I would say the "best" way
would be to journal the file, and examine what the program(s) are that 
are causing the condition....


On 5/30/2014 10:15 AM, Jeff Young 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