Hi,

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?

I'm using Informix 5 on a Sparc 10 with SunOS 4.1.3.

Regards and thanks in advance,

Chee Meng

--
---------------------------------------------------------------------

Information Technology Institute, Singapore

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?

|> 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