Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Sep 2002 @ 20:02:05 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023