Re: informix SQL pretty formatter?

Check out http://www.iiug.org/software From: username <username@bbn.com> > >(First time post to this newsgroup, and first time using netscape as a >newsreader >so please be understanding if I've violated any netiquette for this >group.) > >I *HAVE* looked for a FAQ for this newsgroup - No joy. Also tried >searches on >Deja-News and Alta-Vista but with no success. > >I'm looking for a pretty-printer / reformatting program for Informix SQL >source. > >I have experience in writing SQL using Teradata and Oracle, but I've >recently >inherited over 100 Informix queries / updates whose formatting is, well, > >"different" and inconsistent. And the code is undergoing revisions, so >I'm >working against a moving target. > >I wrote an AWK script to parse and reformat some of the simple stuff, >but started >to run into problems with quoted strings and nested expressions and >sub-queries. >I'd rather not have to code an entire SQL parser! > >It then hit me that I've seen pretty printer programs for C and for HTML >code... >there's probably ones for SQL, too. > >Does anyone here know of such a thing? Any and all pointers would be >welcome! > >Background: > Database: Informix 5.1 (ya, I know - it's old!) > Platform: SunOS 5.7 > >I also have Windows boxen available (95 and NT) and the MKS Toolkit so >an >IDEAL solution would allow me to do reformatting on either of these >platforms. >Never hurts to ask for what you want, right? > >TIA! >- MartyB > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com