Re: SYSTEM call from trigger error SOLVED

Posted in 1998

glyn_balmer_at_erith3@smtpgwy.supertension.com — Wed, 03 Jun 98 12:14:33 GMT — source: Informix-list mailing list archive (1991-1998)

jonatho@catalinaltg.com (Jonathan Oei) wrote :- >> On Fri, 29 May 1998 16:24:24 GMT, jonatho@catalinaltg.com (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. >> [ snip ] comments about SQLERROR 668, ISAM 172 > Thanks to Paul Watson, Mark Oberfield and Peter Lancashire > It turned out to be a changed environment variable (INFORMIXSERVER) > The DBA had changed it and hadn't told anyone. DBA's are like that ! Glyn Balmer DBA BICC Cables Limited Erith Kent UK