RE: system SQL command wont work
My guess is that workdir != "/tmp" instead it is = "/tmp
"
you will most likely have to find a way to use workdir 'clipped'
> -----Original Message-----
> From: Peter Groarke [SMTP:peter.groarke@credo.ie]
> Sent: Friday, February 06, 1998 9:54 AM
> To: informix-list@iiug.org
> Subject: system SQL command wont work
>
> Hi,
> In a stored procedure I am trying to execute the system command,
> passing it an absolute filename, some of the components of which are
> variables.
>
> For example:
>
> -------------------------------------------
> create procedure blah()>
> define workdir char(64);
> let workdir="/tmp"
>
> system "echo hi >> " || workdir || "/foo" ;
>
> end procedure;
> -------------------------------------------
> (NB Works when I echo to "/tmp/foo")
>
> When executed always gives the SQL error 668, ISAM 172.
> I have tried other ways of building up the string but with
> no success.
>
> Any help much appreciated
>
> Thank you
>
> Peter Groarke