Purges all cache entries associated with a specified physical table name (fully qualified) for the repository to which the client has connected.
This function takes up to four parameters representing the four components (database, catalog,schema and table name proper) of a fully qualified physical table name. For example, you might have a table with the fully qualified name of DBName.CatName.SchName.TabName. To purge the cache entries associated with this table in the physical layer of the Siebel Analytics repository, execute the following call in a script:
Call SAPurgeCacheByTable(‘DBName’, ‘CatName’, ‘SchName’, ‘TabName’);
Wild cards are not supported by the Siebel Analytics Server for this function. Additionally,DBName and TabName cannot be null. If either one is null, you will receive an error message.