Re: System call in a stored procedure
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/