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

Try DataDirect Drivers Now
Call Limit Clause

Purpose

The Call Limit clause specifies the maximum number of Web service calls that can be used to populate or refresh the cache; it is optional.

Syntax

[CALL_LIMIT {0 | -1 | max_calls}]
where:
0
specifies no call limit.
-1
resets the call limit back to its default, which is 0 (no call limit).
max_calls
is a positive integer that specifies the maximum number of Web service calls.
The default value is 0.

Notes

*The call limit for a cache is independent of the Stmt_Call_Limit set on a database session. See "Alter Session (EXT)" for details.
If the call limit of a cache is exceeded during the population or refresh of the cache, the cache is marked as partially initialized. At the next refresh opportunity, the driver attempts to complete the population or refresh of the cache. If the call limit (or other error) occurs during this second attempt, the cache becomes invalid and is disabled. All data in the cache is discarded after the second attempt to populate or refresh the cache fails. Before re-enabling the cache, consider altering the cache definition to allow more Web service calls or specify a more restrictive filter, or both.