>>>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.
In our case we're adding records to tables in table buffered mode.
If it's not broken, fix it until it is.
My Blog