RE: informix SQL pretty formatter?
The 4gl one works OK with SQL. There's one that makes the case consistent and then feed that in to the formatter. Alternatively just merger the source to give you what you want Paul Watson # WF Software Ltd # You are only young once Tel: +44 1436 674729 # but you can be immature Fax: +44 1436 678693 # forever www.wfsoftware.com # > -----Original Message----- > From: Ed Brown [mailto:ebrown@computer-systems.com] > Sent: Tuesday, June 20, 2000 4:54 PM > To: informix-list@iiug.org > Subject: 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 > > > > The contents of this e-mail are confidential to the ordinary user(s) of the mail address(es) to which it was sent and may be legally privileged. If you are not the intended recipient, any disclosure, copying, distribution or use of it, or any part of it, in any form whatsoever, and any actions taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.
Try WinSQL at http://www.indus-soft.com/winsql
Try WinSQL at http://www.indus-soft.com/winsql