Initial Check Clause
- Last Updated: January 12, 2018
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
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.
- DEFAULT
- resets the value back to its default, which is
FIRSTUSE.