Re: Enable or disable trigger while the file is in use.

Thanks Sue, Art, Alan, x y,

Sue, good link to know.

Art, I had the same feeling about environment variable.

x y, I already suspected that <g>

Thanks much for the help, back to forest fires.
John

<snip>
------------------------------
from: Sue Romano <slromano@xxxxxxxxxx>
subject: Re: Enable or disable trigger while the file is in use.

I am not commenting on whether this used to be allowed, or whether it should be allowed. I don't have that answer without doing some research.

I would like to point out an IBM solution that can be helpful for making trigger modifications in a production environment. You can let your environment gradually shift from using the old trigger to a new trigger through the use of a QAQQINI option.

It's been available since 2015. Read more about it here.
https://urldefense.com/v3/__https://www.ibm.com/support/pages/node/1167910__;!!JAIo9NhAvg!tltkzfBN3uK5V7JV3Llz28GM6hf4eDOObPv79_16dE6a-kqj59HoiL-dL5YculVKhPylH20Hedl5rZa3eH0LzhVGxukCJhrUbQ$
------------------------------
from: "Art Tostaine, Jr." <atostaine@xxxxxxxxx>
subject: Re: Enable or disable trigger while the file is in use.

There was an environment variable I think. I don't know what it is unfortunately.
------------------------------
from: Alan Campin <alan0307d@xxxxxxxxx>
subject: Re: Enable or disable trigger while the file is in use.

To my understanding you could not add or remove triggers on a table while in use until a few years ago but then IBM gave you the ability to do it but it is very slow and may or may not work. I have used the support a few years ago when a table was in use and it worked but as I recall another time it did not work. Best, use a mediator.
------------------------------
from: x y <xy6581@xxxxxxxxx>
subject: Re: Enable or disable trigger while the file is in use.

Sue, thank you--this is perfect.
John, you may very well be losing it.
</snip>