RE: System command in procedure problem: Help
Looks like environment. Can you write to the directory that the
file is to go to? If you remove the system calls does the SPL work,
if it does then it must be an environment problem
Paul Watson #
WF Software Ltd # You are only young once
Tel: +44 1436 674729 # but you can be immature
Fax: +44 1436 678693 # forever
www.wfsoftware.com #
> -----Original Message-----
> From: dejongsg@my-deja.com [mailto:dejongsg@my-deja.com]
> Sent: Tuesday, June 20, 2000 5:06 PM
> To: informix-list@iiug.org
> Subject: 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.
>
The contents of this e-mail are confidential to the ordinary user(s) of the
mail address(es) to which it was sent and may be legally privileged.
If you are not the intended recipient, any disclosure, copying, distribution
or use of it, or any part of it, in any form whatsoever, and any actions
taken or omitted to be taken in reliance on it, is prohibited and may be
unlawful.