Re: system SQL command wont work
In article <34DB241B.5FFC@credo.ie>,
Peter Groarke <peter.groarke@credo.ie> wrote:
>
> 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" ;
>
I guess you should try:
system "echo hi >> " || TRIM(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
>
-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/ Now offering spam-free web-based newsreading