Re: Help: system call inside stored procedure

Low Chee Meng asked: |> >I'm having problems make the SYSTEM call work inside a stored procedure. |> >For example, |> > |> >create procedure echo1(msg char(80)) |> >system "/usr/bin/echo msg"; |> >return; |> >end procedure |> > |> >When I do a execute procedure echo1("hello world"), |> >I got back this error message: |> > |> >668: System command cannot be executed |> > 1: Not owner |> > |> >Anybody has any idea what is happening here? Jonathan Leffler writes: |> I just tried your procedure using OnLine 5.01.UC1 on SunOS 4.1.3 and had no |> trouble with any error messages. Obvious things to check: you have execute |> permission on /usr/bin/echo (I thought so), and your shell can also be |> handled run by a sgid informix program? Also check the permissions on $INFORMIXDIR/bin/sgidsh, which should be: -rwsr-sr-x 1 root informix 172032 Jun 22 1992 bin/sgidsh Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney