Re: Stored Procedure - cannot include a system call

In article <70g4ke$vh9$1@nnrp1.dejanews.com>, kcj@mechoshade.com writes >When I include a system call in a stored procedure I get an error when I >attempt to execute it. > > 668: System command cannot be executed. > 1: Not owner> >I am the owner of the database. I get the same message when I log on as >/usr/informix > >The stored procedure is as follows: >----------------------------------------- >CREATE dba PROCEDURE call_wo (vwo INT) > system "echo 'test this'"; system "/bin/echo 'test this'"; or whereever echo is. You should assume you have no environment variables set when stored procedures are executed even $PATH. >END PROCEDURE >----------------------------------------- > >Can anyone give me any ideas as to what could be wrong here. > >I am running INFORMIX se 7.10 under SCO 3.2.4.2 > >Kate Juliff > > > > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care