Re: informix SQL pretty formatter?

Check on the Informix International User Group site at http://www.iiug.org/ . They have some freeware utilities there. I know there are "beautifiers" for 4GL there, but I'm not sure about ISQL. "username" <username@bbn.com> wrote in message news:394F7775.BEFAFDCB@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 >