Archives of the TeradataForum

Message Posted: Mon, 06 Nov 2006 @ 17:41:38 GMT


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

Subj:		Re: Text editor

From:		Dieter Noeth

Mike Dempsey wrote:

This looks like a simplified version of the editor that is built into SQL Assistant version 7.2 (Available later this month)

There are lots of editors with customizable highlighting, but just a few are free *and* good at the same time...

I use ConText quite a lot, because it is so much better than QueryMan's editor, which is probably comparable to Notepad :-)

And i already use SA 7.2 and like the new features, especially multi-level undo and highlight/uppercase on the fly, this was missing for a long time. Only Ctrl-Q/Format is still a bunch of cr**, er, could well be improved :-)

But as there's highlighting on the fly now, there's no need for pressing Ctrl-Q. In fact now i cut&pasted some old scripts in SA just to get the UPPERCASE keywords.

Btw, anybody knows of a freeware SQL code formatter, which is *not* putting a line break after each FROM, e.g. in EXTRACT? Would be nice, if it knows Teradata SQL like QUALIFY...

I already know:

www.sqlinform.com

SQL*Review at www.dbainfopower.com

Some Online SQL Formatters based on "General SQL parser", e.g. www.wangz.net

The language files for SQL Assistant use XML rather than text, but allow you to specify mostly the same type of options. SQLA does however allow you to specify regular expressions rather than just which characters are allowed in things like numerics so it would not highlight '123..4' as a numeric value.

Either way it's not valid SQL :-)

(Language definitions are provided for ANSI, Teradata, Oracle, DB2, Informix, Microsoft, Sybase, MySql.)

Some keywords are missing from Teradata and ANSI .lng files

Dieter


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

Attachments

Library

Quick Reference