Re: Not owner ,668: system command cannot be executed
Obnoxio The Clown wrote:
>
> *I* think the problem is the word "oracle" -- take that out and everything
> will be better... :0)
Way to go, Clownster . . . . (as another flame war erupts, maybe??
Depends on who's lurking) . . . . 8-)
>
> From: "Carlson@WHSmith" <carlson1@bellsouth.net>
> >
> >Matt Phillips wrote:
> > >
> > > 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
> > >
> >
> >Here's a possibility:
> >
> >create procedure inf2ora_extuser(app_manager char(30))> >system "echo 'unload to ""/tmp/user.dat"" select ""ops$""||username"||
> >",""oracle"" "||
> >"from sysusers where username not matches ""public""' > /tmp/user.sql";
> > -- system "dbaccess "||app_manager||" /tmp/user";
> >-- system "rm /tmp/user.sql";
> >end procedure
> >
> >
> >When a redirect is run in this manner, determining where the output file
> >is created can be quite difficult. I always use a hard path, just to
> >make sure.
> >
> > > Platform Solaris 7
> >
> >Ours is HPUX 10.20
> >
> >
> >--
> >John Carlson
> >Informix DBA
> >WHSmith USA
> >
> >#include std_disclaimer.h /* These are my opinions, not my company's
> >opinion */
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
--
John Carlson
Informix DBA
WHSmith USA
#include std_disclaimer.h /* These are my opinions, not my company's
opinion */