Once a cache has been created, you can modify the definition of the cache or set of related caches with the Alter Cache statement (see Alter Cache (EXT)). Only the attributes of the cache can be modified through the Alter Cache statement; the table or related set of tables cannot be changed and a single table cache cannot be changed to a relational cache.
Warning: Changing the attributes of a cache may cause the current data in the cache to be discarded and refetched from the remote data source.
