Recently I had to develop very complex SQL statements to get data from i5 systems, using NSFDB2 and federation on R8: problem is SQL statements in Query Views (QV) cannot be just pasted as text in the SQL formula area, I had to remove all carriage returns, extra-spaces and so on... Everything should be on "one row"...
For that I used a good text editor called Notedap++, that was very handy.
Later on, I had to reverse the "just one line" SQL statement to a readable format, formatted in easy way, something like a beautifier for SQL statement.
After some googling I found a very good tool called SQLinForm !
- it's free
- it's written in Java
- it can be used online in a web browser and also offline
- it process several SQL dialects
- it can output the newly formatted SQL statements to several programming languages
- it formats SQL keywords using colors
- other handy features...