By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

 


Query window Enhancements (enter skips to next line in a textbox)

The Query Window is an Excel based tool that attempts to provide similar logic as a program like toad.

It's written in Excel and solve a problem where accessing Netezza database you lose connections.
1.Find/Replace (can do it via the parms)
2.Save to drop-down (bring up form and ask for name, table, query
3.Support -- comments
4.Support scroll wheel
5.Find common syntax errors
6.Track wait time
7.Monitor response time and give estimate
8.Log all queries you run with errors/problems/timings
9.Help to build queries (maybe just use access)
10.Cancel a query
11.Prompt for parameters
12.Check if tables have indexes
13.Save results to multiple sheets instead of overlaying to same one
14.Run/load from a file
15.Help speed up run time by using some sort of <include statement>
16.Status bar/estimate of run time
17.Look for view opportunities (where you use the same join often)
18.
19.Load code snippets like rank to lookup
blog comments powered by Disqus