>>But if you get the file and just import it in some other table, you don't need WITH (BUFFERING=.t.), you didn't change the file before importing, right?
>>What happens if you FLOCK() table before you insert records?
>
>This program is not mine and very long and complex. We may try to use flock(), I'm still thinking, should I forget about with buffering and try a different approach?
If you don't change table before import you don't need buffering=.t., even if you change table, but it is not in Buffering mode you don't need this clause.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.