Contents Index AUTO_COMMIT option [ISQL] AUTOMATIC_TIMESTAMP option [compatibility]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

AUTO_REFETCH option [ISQL]


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, the current query results that appear on the Results tab in the Interactive SQL Results pane 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.


Contents Index AUTO_COMMIT option [ISQL] AUTOMATIC_TIMESTAMP option [compatibility]