· Jan 15, 2020

sql statements - how to clear multiple sql statements and Frozen Flags

cache 2017.2.1 (Build 801_3)

when I look into the "sql statements" ( sql page of the management portal ) I have lots of old statements with a lot of them frozen. many of them are %sqlcq routines (I believe these are the SLQ's I run when testing/running random SQL queries in the sql page. )

I can clearly see where I can click on an individual query and untick an individual query to unfreeze it. or delete it. but thats a painful slow process. I can't see anywhere to delete/change multiple queries

I want to programmatically remove all the %sqlcq queries from the list and then start looking at all the remaining queries,

has anyone got any code that allows me to

  • delete certain queries from that list
  • remove "frozen" from the queries
  • ultimately clear the entire list and let the list grow again with all the new 'unfrozen' queries

all of this is NOT being done on LIVE data, it's a copy for experimenting on the SQL.

I can then run stats on the LIVE data and then the copy data comparing the two

Discussion (2)0
Log in or sign up to continue