Re: SYSTEM call from trigger error

On Fri, 29 May 1998 18:08:28 +0100, Paul Watson <watson@mcmail.com> wrote: > Jonathan Oei wrote: > > > We are using Informix On-Line 7.20.UC3 and have a simple trigger on a > > table that fires after an insert. During the trigger, we build a > > string that contains a path to an external .4ge program. > > > > So far, so good, this has been working for months. > > > > But now, we get this error from the trigger trace: > > > > exception : looking for handler > > SQL error = -668 ISAM error = -172 error string = = ""> > exception : no appropriate handler > > [cutting] > > If it working from command line and not from the trigger then it must be > path, permissions or environment. Change the 4ge to a simple shell script > that records its running environment and compare it to that of the working > command line code. Great idea, but we can't even get the trigger to call a simple shell script. We tried one that would echo "Hello", and we still got the same error. I would also agree that it seems to be a permissions/path problem except that the system call gets the full path name, and that the permissions of the directories down (up?) to the target are 777'd.