RE: ExternalRE: Stopping/Starting Triggers
Eric Wolf <[email protected]> Tue, 10 Mar 2026 20:24:17 +0000
| Newsgroups | gmane.comp.lang.as400.rpg |
|---|---|
| Message-ID | <[email protected]> |
Jerry, Just for some additional information - I think that the enhancement request that I added to allow for a single file to be used with those commands may still be open. If it is, you may want to either acknowledge or agree with that request. Eric A. Wolf Sr. Program Developer 2980 N. San Fernando Blvd.<https://www.google.com/maps/place/2980+N+San+Fernando+Blvd,+Burbank,+CA+91504/@34.2016192,-118.3414462,17z/data=!3m1!4b1!4m2!3m1!1s0x80c29506b13e342b:0x8e7c0e2b16b32dff> Burbank, CA 91504-2566<https://www.google.com/maps/place/2980+N+San+Fernando+Blvd,+Burbank,+CA+91504/@34.2016192,-118.3414462,17z/data=!3m1!4b1!4m2!3m1!1s0x80c29506b13e342b:0x8e7c0e2b16b32dff> [cid:image001.png-8yYkA/yJNZZya/[email protected]] (818) 260-2936 [cid:image002.jpg-8yYkA/yJNZZya/[email protected]] (818) 669-0636 [cid:image003.png-8yYkA/yJNZZya/[email protected]] [email protected]<mailto:[email protected]> [cid:image004.png-8yYkA/yJNZZya/[email protected]]<https://seniorssp.com/> A division of Senior Operations LLC From: RPG400-L <rpg400-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> On Behalf Of Jerry Forss Sent: Tuesday, March 10, 2026 1:15 PM To: RPG programming on IBM i <[email protected]> Subject: RE: ExternalRE: Stopping/Starting Triggers Thanks Eric That's what I am looking for. Yes, all our triggers are in XA. This was Infor's response. Is it correct to remove the triggers CALL AMZTRG7R 'MBC6REP To readd the triggers CALL AMZTRG4C 'MBC6REP' No Once you perform CALL AMZTRG7R NkdkJdXPPEBannerStart External Sender - From: (Jerry Forss <[email protected]>) This message came from outside your organization. This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. NkdkJdXPPEBannerEnd Thanks Eric That's what I am looking for. Yes, all our triggers are in XA. This was Infor's response. Is it correct to remove the triggers CALL AMZTRG7R 'MBC6REP To readd the triggers CALL AMZTRG4C 'MBC6REP' No Once you perform CALL AMZTRG7R 'MBC6REP' it will remove and add the triggers that are defined in the file TRGMST at a time. AMZTRG4C this command used for all files, not a specific file. Unfortunately, with one command or call program you cannot remove the triggers and perform some operations and add it back. Although For removing you can use RMVPFTRG FILE(filename) TRGTIME(*ALL) - check whether it removes all triggers in one go. Hope it will remove otherwise remove one by one. But for adding it should be done one by one like For inserts: ADDPFTRG FILE(filename) TRGTIME(*BEFORE) TRGEVENT(*INSERT) PGM(XLIB/MZU360XP) For deletes: ADDPFTRG FILE(filename) TRGTIME(*BEFORE) TRGEVENT(*DELETE) PGM(XLIB/MZU360XP) For updates: ADDPFTRG FILE(filename) TRGTIME(*BEFORE) TRGEVENT(*UPDATE) PGM(XLIB/MZU360XP) TRGUPDCND(*CHANGE) There is no specific command to add all the trigger events to a single file at a time. -----Original Message----- From: RPG400-L <rpg400-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org<mailto:rpg400-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org>> On Behalf Of Eric Wolf Sent: Tuesday, March 10, 2026 3:10 PM To: RPG programming on IBM i <[email protected]<mailto:[email protected]>> Subject: ExternalRE: Stopping/Starting Triggers Jerry, Are you adding your triggers to the XA Trigger Master database? If no, you may want to consider doing this so that anytime XA ends the triggers and starts the triggers, you will not have to handle yours manually. If yes, you can use the following XA commands from an XA command line: To end all XA triggers: CALL AMZTRG4C PARM(*REMOVE) To start all XA triggers: CALL AMZTRG4C PARM(' ') Eric A. Wolf Sr. XA Program Developer From: RPG400-L <rpg400-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org<mailto:rpg400-l-bounces-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org>> On Behalf Of Jerry Forss Sent: Tuesday, March 10, 2026 11:43 AM To: [email protected]<mailto:[email protected]> Subject: Stopping/Starting Triggers Part of my file purge process is going to end triggers on a file, pruge the records, reorg the file and readd the triggers. Is there any concerns with doing the CHGPFTRG FILE(Lib/File) TRG(*ALL) STATE(*DISABLED) Do my purging, and then CHGPFTRG NkdkJdXPPEBannerStart External Sender - From: (Jerry Forss <[email protected]<mailto:[email protected]>>) This message came from outside your organization. This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. NkdkJdXPPEBannerEnd Part of my file purge process is going to end triggers on a file, pruge the records, reorg the file and readd the triggers. Is there any concerns with doing the CHGPFTRG FILE(Lib/File) TRG(*ALL) STATE(*DISABLED) Do my purging, and then CHGPFTRG FILE(Lib/File) TRG(*ALL) STATE(*ENABLED) I am asking Infor XA as well being it is on all their files. I was going to get a list of the triggers and do RMVPFTRG FILE(LIB/FILE) TRGTIME(*ALL) TRGEVENT(*ALL) TRG(*ALL) Do my purging, and then for each trigger do the ADDPFTRG. Thoughts? Subject to Change Notice: WalzCraft reserves the right to improve designs, and to change specifications without notice. Confidentiality Notice: This message and any attachments may contain confidential and privileged information that is protected by law. The information contained herein is transmitted for the sole use of the intended recipient(s) and should "only" pertain to "WalzCraft" company matters. If you are not the intended recipient or designated agent of the recipient of such information, you are hereby notified that any use, dissemination, copying or retention of this email or the information contained herein is strictly prohibited and may subject you to penalties under federal and/or state law. If you received this email in error, please notify the sender immediately and permanently delete this email. Thank You WalzCraft PO Box 1748 La Crosse, WI, 54602-1748 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo0PgPtFVCO4GY&s=CrYOnWe-Gx69h6UnhVuCRVD1-2em9qtu9vLxacVamZ0&e=<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo0PgPtFVCO4GY&s=x0Za0D2iw2Q3HuyQxWq1ZL1fQyt5jxSG7YQqhi4NgQE&e=<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo 0PgPtFVCO4GY&s=CrYOnWe-Gx69h6UnhVuCRVD1-2em9qtu9vLxacVamZ0&e=%3chttps://urldefense.proofpoint.com/v2/url?u=https-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf 9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo0PgPtFVCO4GY&s=x0Za0D2iw2Q3HuyQxWq1ZL1fQyt5jxSG7YQqhi4NgQE&e=<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo0PgPtFVCO4GY&s=CrYOnWe-Gx69h6UnhVuCRVD1-2em9qtu9vLxacVamZ0&e=%3chttps://urldefense.proofpoint.com/v2/url?u=https-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo0PgPtFVCO4GY&s=x0Za0D2iw2Q3HuyQxWq1ZL1fQyt5jxSG7YQqhi4NgQE&e=%3chttps://urldefense.proofpoint.com/v2/url?u=http-3A__www.walzcraft. com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo0PgPtFVCO4GY&s=CrYOnWe-Gx69h6UnhVuCRVD1 -2em9qtu9vLxacVamZ0&e=%3chttps://urldefense.proofpoint.com/v2/url?u=https-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo0PgPtFVCO4GY&s=x0Za0D2iw2Q3HuyQxWq1ZL1fQyt5jxSG7YQqhi4NgQE&e=>>> Phone: 1-800-237-1326 -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected]<mailto:[email protected]<mailto:[email protected]%3cmailto:[email protected]>> To subscribe, unsubscribe, or change list options, visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo0PgPtFVCO4GY&s=sCsXyyKkfxBqyMaz05wAQuEteaUb2pqnD5eRBepG8_k&e= or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org<mailto:RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org<mailto:RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org%3cmailto:RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org>> Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=GBoNkyHElv56Elzpn8CXXXXmKKPxiObWQdX_i7q-tAj_GWnnYhPo0PgPtFVCO4GY&s=GTQNlbkO-fLdW4t8iCDPIpWzV36eL_UqrxWQ4JfV29A&e=. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org<mailto:support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org<mailto:support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org%3cmailto:support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org>> for any subscription related questions. ---------- This email has been scanned for spam and viruses. Visit the following link to report this email as spam: https://us-spambrella.cloud-protect.net/app/report_spam.php?mod_id=11&mod_option=logitem&report=1&type=easyspam&k=k1&payload=53616c7465645f5fafcab655ac5af7f9cf65c5d4d93211c14895eeef175f497d2bf87a24a5bc6cb9f399836a3f62d24647cf749d8bc4a90069fc7e8808cdf7bdf0ba9aae7f6e4ad9a7a97ac56bd15be45c090086e3eed4db99ede2e96395dd5679302e5a8cef0868b7c86d87197b9ccd5e619eddb68a6422e4d3d39b84ea2192a66d71df0feca1b46c8a06dc0df2f908dd224069121cee8f719de990e3cb2a04 This communication is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise exempt from disclosure under applicable law. If you are not the intended recipient, or the employee or agent responsible for delivering this communication to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by telephone or email. The technical data herein provided is subject to export control under the International Traffic in Arms Regulations (ITAR) or the Export Administration Regulations (EAR). Such data should not be disclosed, exporte d or transferred in any manner to any foreign person or any foreign country without prior written approval of the Office of Defense Trade Controls, U.S. Department of State or the Bureau of Industry and Security, U.S. Department of Commerce. This email and any attachments may contain confidential and proprietary information and must be treated as such. In addition, the export or re-export of this information may be prohibited under applicable export control laws. -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected]<mailto:[email protected]> To subscribe, unsubscribe, or change list options, visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=aIfH8x2axCpJvjJno5VQBPr1HVeNXu3Xqj42Jhq0mFkjktR6yKUr8ZR8CutB9JnG&s=y65cdb38DNXmLOl1K4nCLmSilmohL--cM91nB7MnVvw&e= or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org<mailto:RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=aIfH8x2axCpJvjJno5VQBPr1HVeNXu3Xqj42Jhq0mFkjktR6yKUr8ZR8CutB9JnG&s=tZattBGhM2VVme3UID7IeWvxPz_BsieuIZ24jnH412s&e=. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org<mailto:support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org> for any subscription related questions. CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. Subject to Change Notice: WalzCraft reserves the right to improve designs, and to change specifications without notice. Confidentiality Notice: This message and any attachments may contain confidential and privileged information that is protected by law. The information contained herein is transmitted for the sole use of the intended recipient(s) and should "only" pertain to "WalzCraft" company matters. If you are not the intended recipient or designated agent of the recipient of such information, you are hereby notified that any use, dissemination, copying or retention of this email or the information contained herein is strictly prohibited and may subject you to penalties under federal and/or state law. If you received this email in error, please notify the sender immediately and permanently delete this email. Thank You WalzCraft PO Box 1748 La Crosse, WI, 54602-1748 https://urldefense.proofpoint.com/v2/url?u=http-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=aIfH8x2axCpJvjJno5VQBPr1HVeNXu3Xqj42Jhq0mFkjktR6yKUr8ZR8CutB9JnG&s=_SVBBkI1Z194cEiyK2grN3nDfXY1sTpZMHSrUx8Iizc&e=<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=aIfH8x2axCpJvjJno5VQBPr1HVeNXu3Xqj42Jhq0mFkjktR6yKUr8ZR8CutB9JnG&s=i3r0fMCbFPOPqLrLqR3mCNM7NA28OoKNYgsYO-9k-j4&e=<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=aIfH8x2axCpJvjJno5VQBPr1HVeNXu3Xqj42Jhq0mFkjktR6yKUr 8ZR8CutB9JnG&s=_SVBBkI1Z194cEiyK2grN3nDfXY1sTpZMHSrUx8Iizc&e=%3chttps://urldefense.proofpoint.com/v2/url?u=https-3A__www.walzcraft.com&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf 9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=aIfH8x2axCpJvjJno5VQBPr1HVeNXu3Xqj42Jhq0mFkjktR6yKUr8ZR8CutB9JnG&s=i3r0fMCbFPOPqLrLqR3mCNM7NA28OoKNYgsYO-9k-j4&e=>> Phone: 1-800-237-1326 -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected]<mailto:[email protected]> To subscribe, unsubscribe, or change list options, visit: https://urldefense.proofpoint.com/v2/url?u=https-3A__lists.midrange.com_mailman_listinfo_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=aIfH8x2axCpJvjJno5VQBPr1HVeNXu3Xqj42Jhq0mFkjktR6yKUr8ZR8CutB9JnG&s=y65cdb38DNXmLOl1K4nCLmSilmohL--cM91nB7MnVvw&e= or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org<mailto:RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org> Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=https-3A__archive.midrange.com_rpg400-2Dl&d=DwICAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=PCeNSf9fhcAUxJzoAZa9Db8EQ_28MTQACuQxevMqYzc&m=aIfH8x2axCpJvjJno5VQBPr1HVeNXu3Xqj42Jhq0mFkjktR6yKUr8ZR8CutB9JnG&s=tZattBGhM2VVme3UID7IeWvxPz_BsieuIZ24jnH412s&e=. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org<mailto:support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org> for any subscription related questions. ---------- This email has been scanned for spam and viruses. Visit the following link to report this email as spam: https://us-spambrella.cloud-protect.net/app/report_spam.php?mod_id&mod_option=logitem&report=1&type?syspam&k=k1&payloadS616c7465645f5fb7ad6c91a99aa64810dec1178ca6ec8595a83cf00a6233c1f43cf6d852a2adc031e633f01a7863585f60007bfff78e5c00ca264cca0f491e23406d67e263676b578bc1d9f76d4af2fbe3afd131e8975a3c6bfb6fecd26079932912e23a5e0ba3d434641d350b150fe13f8d26a10eaaee5b0a53554caa930093ad227934189673cc87c7f8faf41597572ada0f69e2e20cf57a61b0ef3ab364 This communication is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise exempt from disclosure under applicable law. If you are not the intended recipient, or the employee or agent responsible for delivering this communication to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by telephone or email. The technical data herein provided is subject to export control under the International Traffic in Arms Regulations (ITAR) or the Export Administration Regulations (EAR). Such data should not be disclosed, exporte d or transferred in any manner to any foreign person or any foreign country without prior written approval of the Office of Defense Trade Controls, U.S. Department of State or the Bureau of Industry and Security, U.S. Department of Commerce. This email and any attachments may contain confidential and proprietary information and must be treated as such. In addition, the export or re-export of this information may be prohibited under applicable export control laws. -- This is the RPG programming on IBM i (RPG400-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l. Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.