|
Using an RPG program as a trigger program is not a problem. Do you have that same trigger program on other files or do the other files have trigger programs which update this file? ----- Original Message ----- From: a b <eagle_291@yahoo.com> To: <RPG400-L@midrange.com> Sent: Friday, March 17, 2000 1:37 PM Subject: Unable to Execute Trigger..? > Hello everyone... ! > > I was wondering if someone could possibly point me in > the right direction or tell me what it might be that > I'm doing wrong. I'm trying to execute an RPG program > from a Physical File Trigger after and SQL insert is > performed, but it continues to crash. Will a trigger > ONLY call a CL program, or will it call an RPG? > > My attempt is to perform the following; Insert a row > into a physical file, execute an RPG program which > then performs data population in other files. > > Any help would greatly be appreciated. I've included > the a couple of the errors which have displayed every > time I attempt to update the triggered physical file. > > Any help would greatly be appreciated. > > Thanks > AB > --- ERRORS ----------------------------------------- > > Message . . . . : An error in the trigger program > was detected before WRITE > on file EXXXXX1PX (C G D F). > > Cause . . . . . : RPG procedure EFXXX1R in program > MISTEMP/EFXXXK1R > detected an error in the trigger program before > WRITE operation was done on > file EFXXX1PX. The actual file is > MISTEMP/EFDXXX1PX(EFXXXXR1P). The WRITE > operation was not performed. > > > Message . . . . : EFDXXX1R was called recursively. > > Cause . . . . . : RPG procedure EFDXXXX1R in > program MISTEMP/EXXXXK1R > called itself or another procedure which then > called procedure EXXXX1R. > > ---------------------------------------------------- > > > > > > __________________________________________________ > Do You Yahoo!? > Talk to your friends online with Yahoo! Messenger. > http://im.yahoo.com > +--- > | This is the RPG/400 Mailing List! > | To submit a new message, send your mail to RPG400-L@midrange.com. > | To subscribe to this list send email to RPG400-L-SUB@midrange.com. > | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. > | Questions should be directed to the list owner/operator: david@midrange.com > +--- > +--- | This is the RPG/400 Mailing List! | To submit a new message, send your mail to RPG400-L@midrange.com. | To subscribe to this list send email to RPG400-L-SUB@midrange.com. | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.