Re: System call in a stored procedure

In article <33B408C7.74F7@administaff.com>, Amy says... > >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. Hiya, Check the ownership of the shared memory segments. They should be root:informix If they are something else, than most likely your installation was either in wrong order or somebody was messing with the permissions of oninit. I have seen this just about a month ago on HP when they installed ESQL/C on top of Online and most likely did something else as well. The remedy here is to reinstall Online, it should not be a problem Cheers Ilya