|
No. You can not add/change a trigger on a physical file when the file is in use. The CHGPFTRG needs to obtain an exclusive lock on the database file. That is why it has been suggested that you have 2 programs for a trigger, the actual trigger program being a CL which simply passes the parameters to your real trigger program in RPG. That way if you need to change the trigger on the fly or remove it, you just change the RPG program which you can do without having to exlusively lock the physical file. Regards, Jim Langston -----Original Message----- From: Graves, Chuck [mailto:cgraves@roddapaint.com] With V5R1, I can disable/enable a trigger via the CHGPFTRG command (as I understand it). Can I do this on the fly, without having an exclusive lock on the object...to prevent a trigger (*ALL triggers) from firing during certain processing periods, and then enable the trigger later in the job stream, again without having an exclusive lock on the object.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
