 |
 |
Archives of the TeradataForum
Message Posted: Fri, 13 Sep 2002 @ 20:02:05 GMT
| Subj: | | An SQL PrettyPrinter??? |
| |
| From: | | Frank C. Martinez IV |
Hola people!
Did I see in a reply from John Grace something about a tool that reformats SQL? Aiii, what I wouldn't give for such a tool. Yes, yes,
I know, SQL isn't really for humans, the tools should generate it (hah!). However, I constantly find myself using things like the color
coding that inTERAgate produces to assist me in reading through such SQL in order to find out exactly why it's eating the machine. And yes,
of course, I do it to my own, as well as having a sort of self-standard for how I tab and organize SQL. All of this helps me to make sense
of the code. So what I'm wondering is what kind of tools you all use to analyse SQL and how successful you are at it. Like I said, I love
Jim Calvert's inTERA stuff (not a commercial product, so I guess I can compliment it publicly). I love 'gate, 'script and especially 'mon
since I can't find the ABORT SESSION OVERRIDE button in Teradata Mangler! (I know it's got to be there somewhere) So what do you use and
how suckysesful is it? How about tools to create test databases based on key values or random samples? Anyway, just a few queries.
iv
| |
