You create a cache using the Create Cache statement (see "Create Cache (EXT)"). A cache can only be created from a single table. When creating a cache, you specify the name of the table to cache and can optionally specify a filter for the table. The filter determines whether the cache holds all of the data in the remote table or a subset of the data that matches the filter. You can also specify attributes for the Create Cache statement that determine:
Whether the cache data is held on disk or in memory
How often the cache data is refreshed
Whether the cache is initially enabled
Whether the driver checks to see if a refresh is needed at connect time
Whether the cache data is held on disk or in memory