AUTO_REFETCH option [DBISQL]

Function

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

Allowed values

ON, OFF

Default

ON

Description

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