Re: append to a spool file
From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Sun, 22 Jul 2001 06:53:06 GMT
Message-ID: <3B39CF8C.13326D6A_at_unilog.fr>
Date: Sun, 22 Jul 2001 06:53:06 GMT
Message-ID: <3B39CF8C.13326D6A_at_unilog.fr>
With Unix you can define a pipe file which is used to be concatened to
another file.
For example, on AIX you have to type :
mkfifo pipe.lst
And then type this each time you want to add a spool to the spool.lst file :
cat pipe.lst >> spool.lst &
sqlplus ... << END
spool pipe
...
exit
END
To avoid to repeat the cat command, you can also put it in a shell
script that call itself (not tested) :
# script copy_pipe.sh
cat pipe.lst >> spool.lst
copy_pipe &
Hope this helps.
Bye
Dina Ghatit a écrit :
>
> When I use the spool command I want to be able to append to the same file.
> Any ideas?
>
> spool myfile
>
> I want to append to myfile each time I run my sqlplus script.
> Thanks.
-- Pierre CHARPENAYReceived on Sun Jul 22 2001 - 08:53:06 CEST