Re: append to a spool file

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 CHARPENAY