Anyone have an SQL Code beautification tool (5b.c)?
Posted in 2005
Hi All,
Does anyone know where I can get a program that turns one line or badly
formatted Sql into nice readable output? I used to have something
called "5b.c + keywords + keytable" which also beautified 4gl but seem
to have lost it. I can't afford the time to write one. Too busy looking
at badly generated Forte SQL.
I'm not thinking ctrl-space in eclipse or code assist type program but
something I can run from command line against multiple files.
Surely there must be an engineer (distinguished or otherwise) somewhere
at IBM that could give it a go? Would be good to ship with product.
e.g.
Orig:
select col1, col2, col3, col4, col5, col6, col7, col8, col9, col10 from
orders, outer order items where orders.order_no = items.order_no andorders.customer_num in (select customer_num from special_customers
where customer_type = "New") and orders.order_type = "X";
New:
select col1, col2, col3, col4, col5, col6, col7, col8,
col9, col10
from orders, outer order items
where orders.order_no = items.order_no
and orders.customer_num in
(select customer_num
from special_customers
where customer_type = "New")
and orders.order_type = "X";
TIA,
Peter.