System call in a stored procedure

Posted in 1997

Amy Cotter — Fri, 27 Jun 1997 13:44:25 -0500 — source: Informix-list mailing list archive (1991-1998)

I am trying to execute a system command from a stored procedure. It works fine when executed by user informix. All other users receive a -668 error (system command cannot be executed) from Informix, with a -1 error (not owner) from AIX. I've made sure that if I'm manipulating files, the permissions are OK. The system command always fails no matter what I place in "" ie, SYSTEM "id>/tmp/id.out" ; SYSTEM "cp /tmp/a /tmp/b" ; SYSTEM "cp $HOME/a $HOME/b" ; I'm running Online 7.12 on AIX v4.1.5. Any suggestions would be greatly appreciated! Thanks.

Related threads

668: System command cannot be executed
SP Question: System Command