informix SQL pretty formatter?
Posted in 2000
Topics: General Discussion
(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