AUTO_REFETCH option [DBISQL]

Controls whether query results are fetched again after deletes, updates and inserts.

ON, OFF

ON

If AUTO_REFETCH is ON, then the current query results will be refetched from the database after any INSERT, UPDATE or DELETE statement. Depending on how complicated the query is, this may take some time. For this reason, it can be turned OFF.