Retrieving Data from the Cache

Data is retrieved from the cache by calling the appropriate functions in the Cache broker schema. These functions are grouped as follows:
  • Channel API
  • Value API
  • Event Metadata API
  • Format API
  • Service Participant API
Note: These API functions should be used throughout the FTM customer specific action code wherever the listed tables and views are currently accessed. Using the API functions will improve the performance of FTM, and reduce the number of database operations performed by the application.
For example, customer specific action code may be accessing the CHANNEL table directly each time CHANNEL details are required for a particular channel with an ID of 1. This code should be replaced by calling the GetChannel function like this: 
DECLARE refChan REFERENCE TO Environment.PMP.Variables.Channel;
CALL Cache.GetChannel(cCacheId, 1, refChan);