System command in procedure problem: Help
I am getting a -668 error when trying to execute a procedure in either
SQL Editor or DB-Access. This is running 7.3 IDS on NT. I have included
the procedure and error message. I have have tryed to modify the
procedure nad still no luck. Thanks.
-- Procedure
create procedure inf2ora_extprep()
define tabname_l like systables.tabname; define procname_l like sysprocedures.procname;
set debug file to 'debug' || '.out'
trace on;
system "echo ''>>extprep.rep";
foreach
select tabname into tabname_l
from systables
where tabtype="T" and tabname like "inf2ora\\_%"
system "echo 'rename table "||tabname_l||" to
xx"||tabname_l||"'>>extprep.rep";
end foreach;
foreach
select procname into procname_l
from sysprocedures
where procname like "inf2ora\\_%"
system "echo 'rename procedure "||procname_l||" to
xx"||procname_l||"'>>extprep.rep";
end foreach;
end procedure;
-----Error Message
execute procedure inf2ora_extprep();-- [Informix][Dynamic Server, Workgroup Edition][vw] SQL Error (-668) :
System command cannot be executed. [ ISAM error -2 : No such file or
directory ]
Sent via Deja.com http://www.deja.com/
Before you buy.
have you tried to fully path your output files, and
make sure they exist, and writable?
dejongsg@my-deja.com wrote:
> I am getting a -668 error when trying to execute a procedure in either
> SQL Editor or DB-Access. This is running 7.3 IDS on NT. I have included
> the procedure and error message. I have have tryed to modify the
> procedure nad still no luck. Thanks.
>
> -- Procedure
>
> create procedure inf2ora_extprep()
> define tabname_l like systables.tabname;> define procname_l like sysprocedures.procname;
> set debug file to 'debug' || '.out'
> trace on;
> system "echo ''>>extprep.rep";
> foreach
> select tabname into tabname_l
> from systables
> where tabtype="T" and tabname like "inf2ora\\_%"
> system "echo 'rename table "||tabname_l||" to
> xx"||tabname_l||"'>>extprep.rep";
> end foreach;
>
> foreach
> select procname into procname_l
> from sysprocedures
> where procname like "inf2ora\\_%"
> system "echo 'rename procedure "||procname_l||" to
> xx"||procname_l||"'>>extprep.rep";
> end foreach;
>
> end procedure;
>
> -----Error Message
>
> execute procedure inf2ora_extprep();> -- [Informix][Dynamic Server, Workgroup Edition][vw] SQL Error (-668) :
> System command cannot be executed. [ ISAM error -2 : No such file or
> directory ]
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
dejongsg@my-deja.com wrote: > I am getting a -668 error when trying to execute a procedure > system "echo ''>>extprep.rep"; 'echo' is internal command of command interpreter. Try system "cmd /c echo ''>>extprep.rep"; > -- [Informix][Dynamic Server, Workgroup Edition][vw] SQL Error (-668) : > System command cannot be executed. [ ISAM error -2 : No such file or > directory ] Absolutely correct message: server can't find echo.exe, echo.com, echo.bat, echo.cmd files because no such files.