RE: Not owner ,668: system command cannot be executed
I have the same problem. I have IDS 7.24.FC6 in an Alpha 2100 Server. When I
make a system call to a 4ge program from a SPL I get the same error problem.
I tried to call a shell instead (setting Informix variables) but it doesn't
function.
As a test i included in the shell the following line code before making the
system call:
touch file1 file2
and it creates the files but fails when calling the 4ge.
What else can i try to do?
Luis
> -----Mensaje original-----
> De: Vivek.CHAUDHARY@st.com [SMTP:Vivek.CHAUDHARY@st.com]
> Enviado el: Mi'rcoles 17 de Mayo de 2000 05:50
> Para: mmp3@pvh.org
> CC: informix-list@iiug.org
> Asunto: Re: Not owner ,668: system command cannot be executed
>
> I think I know the problem. When you make system call all your
> environment setting is lost and hence you find this problem. To
> correct this. From system make a call to a shell script (absolute
> path) and within this script set your entire environment INFORMIXDIR,
>
> PATH, INFORMIXSERVER etc and then following could be any of the
> commands that you want to execute.
>
>
> Vivek
>
>
> ______________________________ Reply Separator
> _________________________________
> Subject: Re: Not owner ,668: system command cannot be executed
> Author: mmp3 (mmp3@pvh.org) at internet
> Date: 5/17/00 10:59 AM
>
>
> Thanks for responding so quickly. Here is the procedure that I am trying
> to
> execute:
>
> create procedure inf2ora_extuser(app_manager char(30))
> system "echo 'unload to ""user.dat"" select ""ops$""||username"||
> ",""oracle"" "||
> "from sysusers where username not matches ""public""' > user.sql";> -- system "dbaccess "||app_manager||" user";
> -- system "rm user.sql";
> end procedure
>
> Platform Solaris 7
> Thanks.
>
>
> Wolfgang Zager wrote:
>
> > Matt Phillips wrote:
> > >
> > > I have created a stored procedure using user informix. When I go to
> > > execute this procedure I get this error. Being user informix I should
> > > not have to specify a database username and password or do I? Any help
>
> > > would be great.
> >
> > It seems, that You a "SYSTEM"-command in Your procedure and something
> > with the command, which should be executed by Your OS doens't work
> > correctly.
> >
> > For a better analysis of Your program, I need Your whole
> > "SYSTEM"-command
> > and the operating system Your database-server is running on.
> >
> > wolfgang
>