Uwe Oeder wrote:

> Thanks that is really cool and just what I needed. Is there a way of
> stopping the OUT statement after it has served its use ? and can one run 2
> SELECT's that however amend to the existing file rather than replace it ?

AFAIK, it will not overwrite, but append to the file.

If you wish to stop writing to file, just type
SQL> out;

That's all.

--
Milan Babuskov
http://fbexport.sourceforge.net