SQL pretty-print -- MIDRANGE-L

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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.