>>>Does the Dynazip terminate eventually? If it does you could start up a timer if your ERASE failed and check periodically to clean up. I spose you could spin until it's cleared but personally I get a bit antsy about tight loops :-)
>>
>>The process normally finish in 1 second. When it jams, it keeps like that for a while. I really don't know why it is hanging like that. I have it about twice a week on about 2 thousands requests.
>>
>>What happen, is after, the system need to assume all is ok and will try to work with the file. In this case, an ERASE will not work. I'll look with Dynazip to see if there is some kind of operation we can do to avoid that or to kill the process.
>
>Perhaps there's a mutual deadlock going on, is the Dynazip waiting on getting a access to a file that you already have open?
We do the SELECT INTO TABLE DBF followed by USE IN ABC. Then, we do the ZIP. As mentioned, this work almost all the times, except in certain situations where I can't find.