>I am having difficulty with COPY FILE xxx TO yyy. The file 'xxx' is open in a grid and an error 'File is in use' is being produced. Anybody have any ideas?
If the file is open you should USE the file AGAIN and use the copy command. Like this:
USE xxx AGAIN IN 0 ALIAS xxxx
SELECT xxxx
COPY TO yyy