-
Re: How can I view all the named queries on a server?
tony.fountain@wtainc.com Nov 27, 2019 10:32 AM (in response to s.hoyer)That's a drawback in DPA, you cannot name multiple queries the same. I just use a pattern of starting with "name-01, name-02, name-03" etc.
-
Re: How can I view all the named queries on a server?
s.hoyer Nov 27, 2019 10:38 AM (in response to tony.fountain@wtainc.com)Ideally, I'd like to remove the name from the one and then name this one correctly. The query as it was is no longer used, and it's been enough days that it no longer shows in my list of bad queries. Is there any place to view all the named queries?
-
Re: How can I view all the named queries on a server?
cpriddyDec 1, 2019 1:28 PM (in response to s.hoyer)
Try querying the hash, name, and descr columns from the CON_SQL_NAME table in the repository.
-
Re: How can I view all the named queries on a server?
s.hoyer Dec 2, 2019 8:39 AM (in response to cpriddy)It'd still be nice to have it in the interface somewhere, but this works. Thanks!
Steve
-
Re: How can I view all the named queries on a server?
cpriddyDec 2, 2019 1:04 PM (in response to s.hoyer)
Agree that an out of the box option to report and manage custom names would be useful. There are a few other query naming related Thwack feature requests as well that would be useful to tackle together.
-
-
-
-