SQL pretty-print

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Well, I googled on "sql formatter" and got a bunch of hits. I downloaded 
one called NiceSQL. It gave the following result:

SELECT IX.DBXLFI, VARCHAR(STRIP(IX.DBXOWN),128),
TB.DBXLFI, VARCHAR(STRIP(TB.DBXOWN),128),
TB.DBXLB2, VALUE(IX.DBXUNQ,SUBSTR(' ',1,1)),
INTEGER(IX.DBXNKF), IX.DBXLB2, IX.DBXFIL,
IX.DBXLIB, TB.DBXFIL, TB.DBXLIB,IX.DBXREM FROM
QSYS.QADBXREF IX, QSYS.QADBXREF TB, QSYS.QADBFDEP
WHERE IX.DBXFIL = DBFFDP AND IX.DBXLIB = DBFLDP
AND TB.DBXFIL = DBFFIL AND TB.DBXLIB = DBFLIB AND
IX.DBXATR = 'IX' AND IX.DBXLIB = 'DB2TX     '

*** EVALUATION VERSION - PLEASE REGISTER ***
SELECT
        IX.DBXLFI,
        VARCHAR(STRIP(IX.DBXOWN), 128),
        TB.DBXLFI,
        VARCHAR(STRIP(TB.DBXOWN), 128),
        TB.DBXLB2,
        VALUE(IX.DBXUNQ, SUBSTR(' ', 1, 1)),
        INTEGER(IX.DBXNKF),
        IX.DBXLB2,
        IX.DBXFIL,
        IX.DBXLIB,
        TB.DBXFIL,
        TB.DBXLIB,
        IX.DBXREM
FROM
        QSYS.QADBXREF IX,
        QSYS.QADBXREF TB,
        QSYS.QADBFDEP
WHERE
        IX.DBXFIL = DBFFDP AND
        IX.DBXLIB = DBFLDP AND
        TB.DBXFIL = DBFFIL AND
        TB.DBXLIB = DBFLIB AND
        IX.DBXATR = 'IX' AND
        IX.DBXLIB = 'DB2TX '
*** EVALUATION VERSION - PLEASE REGISTER ***


Website is http://home.broadpark.no/~ihalvor/ - when you start it up, it 
puts an icon in your system tray, where you can set some options. $20 USD 
if you want to register. You put your statement on the clipboard, press a 
hotkey combination, and the formatted statement is back on the clipboard.

Vern