Re: Not owner ,668: system command cannot be executed
*I* think the problem is the word "oracle" -- take that out and everything
will be better... :0)
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