Subject External tables
Author Dorin Vasilescu
Hi all
Is there a way to close a file handle of an external table file for
embedded server?

I've tried to speed up things by storing static and lookup data in a
local database and to get only transactional data over the wire (DSL
connection). Then get all that is needed for presentation in UI or
reports with a join between an external table filled with remote data
(ids mainly) and tables from local database, using the embedded server.

It works well and very fast, but only first time :(
At the second attempt to fill the external table file, it fails,
because the file is open.

Any ideas?

Or another approach?

Thanks in advance