{fn flushopenfilecache <tablename>}

By executing this extended SQL statement, CONNX closes all open tables and flushes any open data caches.  Table name is an optional parameter.  If omitted all tables in the cache are flushed.

 

Example:

SELECT * FROM customers {fn flushopenfilecache}
to flush all entries in the cache

or

SELECT * FROM customers {fn flushopenfilecache 'customers_rms'}
to flush an individual table