SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 09:28 AM
| ||||
| ||||
 Anyone have an SQL Code beautification tool (5b.c)? 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 and orders.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.      |
Linear Mode
