In article <33B408C7.74F7@administaff.com>,
Amy Cotter <amy_cotter@administaff.com> wrote:
>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.
I have this problem when I'm connecting to a remote server which has not
had a SHELL environment variable defined when the sqlexecd daemon was started.
Check your INFORMIXSERVER settings point to an $INFORMIXDIR/etc/sqlhosts item
which uses the internal connectivity protocol thingy (ie: one of seipcip or
setlitcp, I can't recall which, but not sesoctcp -- I *wish* I had a set of
manuals at home!)
------------------------------------,------------------------------------------
Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.10 May 1997
Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/
New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq
Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/pub/informix/