Re: SYSTEM CALLS/TRIGGERS

In article <446d5f$73n@venice.sedd.trw.com>, irad@oahu.sedd.trw.com says... > I am running OnLine v5.0 and isql/esql v4.10.UE2. I am beginning >to wonder if these functions are supported for my version of Informix. Is Triggers become supported in 5.01, I believe; if you are running 5.00, that's probably the problem. > CREATE PROCEDURE run_cathys_exe () > LET syscall = "/tmp/runtest.ksh";> SYSTEM syscall; > END PROCEDURE; > CREATE TRIGGER auth_changed > UPDATE OF t7a_qth_authorized ON t7a > AFTER (EXECUTE PROCEDURE run_cathys_exe ()); The only syntatical error I see in the above procedure and trigger is that you need to define syscall, as in CREATE PROCEDURE run_cathys_exe () DEFINE syscall char(60); LET syscall = "/tmp/runtest.ksh"; SYSTEM syscall; END PROCEDURE; This runs fine on Informix 5.03. -- William Harris william@carsinfo.com CARS Information Systems http://www.carsinfo.com/~william/ 4000 Executive Park Drive Cincinnati, OH (USA) 45241