skip to main content
Reference : Supported SQL Statements and Extensions : Create Cache (EXT) : Initial Check Clause
  

Try DataDirect Drivers Now
Initial Check Clause

Purpose

The Initial Check clause specifies when the driver performs its initial check of the data in the cache to determine whether it needs to be refreshed; it is optional.

Syntax

[INITIAL_CHECK [ONFIRSTCONNECT | FIRSTUSE | DEFAULT}]
where:
ONFIRSTCONNECT
specifies that the initial check is performed the first time a connection for a user is established. Subsequently, it is performed each time the table or view is used. A driver session begins on the first connection for a user and the session is active as long as at least one connection is open for the user.
FIRSTUSE
specifies that the initial check is performed the first time the table or view is used in a query. Subsequently, it is performed each time the table or view is used.
DEFAULT
resets the value back to its default, which is FIRSTUSE.