By executing this extended SQL statement, CONNX closes all open tables and flushes any open data caches.

 

Example:

SELECT * FROM customers {fn flushopenfilecache}