You can remove the statements in the statement cache using dbcc purgesqlcache. In previous versions of the Adaptive Server, dbcc purgesqlcache deleted the entire contents of the statement cache. Adaptive Server version 15.0.2 enhanced this command to to take in the statement ID as a parameter. The statement IDs are visible in the SSQLID column of monCachedStatement. When you specify the statement ID, only the corresponding statement is deleted from the cache.
The sytax for dbcc purgesqlcache is:
dbcc purgesqlcache (int SSQLID)
