 |
 |
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
| |
