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.

On Tue, Mar 8, 2022 at 1:03 PM Art Tostaine, Jr. <atostaine@xxxxxxxxx>
wrote:

There was an environment variable I think. I don't know what it is
unfortunately.

On Tue, Mar 8, 2022 at 3:34 PM John Rusling via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

Thanks x y, Alan,

I setup these trigger(s) based (somewhat) on Alans mediator design.

Thanks

Alan.

What I really want to know, is did IBM change something with
enabling/disabling triggers?
I -swear- I could enable/disable while the file was in use, 3 or so years
ago. Now I can't enable/disable while the file is in use.

Thanks,
John

<snip>
I thought the only solution was to set a wrapper program as the trigger
and then have the application logic in another program called by the
wrapper.

Question: Am i losing it or did IBM change something?

</snip>
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com