CREATE CACHE ON {remote_table}
[REFERENCING (remote_table_ref[,remote_table_ref]...)]
[REFRESH_INTERVAL {0 | -1 | interval_value [{M, H, D}]}]
[INITIAL_CHECK [{ONFIRSTCONNECT | FIRSTUSE | DEFAULT}]
[PERSIST {TEMPORARY | MEMORY | DISK | DEFAULT}]
[ENABLED {YES | TRUE | NO | FALSE}]
[CALL_LIMIT {0 | -1 | max_calls}]
[FILTER (expression)]The remote table name can be a two-part name: schemaname.tablename. When specifying a two-part name, the specified remote table must be defined in the specified schema, and you must have the privilege to create objects in the specified schema.Is an optional clause that specifies the name of the remote table(s) for which a relationship cache is to be created. See Relational Caches and Referencing Clause for a complete explanation.Is an optional clause that specifies the length of time the data in the cached table can be used before being refreshed. See Refresh Interval Clause for a complete explanation.Is an optional clause that specifies when the driver initially checks whether the data in the cache needs refreshed. See Initial Check Clause for a complete explanation.Is an optional clause that specifies the life span of the data in the cached table or view. See Persist Clause for a complete explanation.Is an optional clause that specifies whether the cache is enabled or disabled for use with SQL statements. See Enabled Clause for a complete explanation.Is an optional clause that specifies the maximum number of Web service calls that can be used to populate or refresh the cache. See Call Limit Clause for a complete explanation.
![]() |
© 2013 Progress Software Corporation and/or its subsidiaries or affiliates. |