NatWest may monitor e-mails for business and operational purposes. The Royal Bank of Scotland plc, National Westminster Bank plc or any affiliated entity ('NatWest' or 'us') does not accept responsibility for changes made to this message after it was sent. Internet e-mails are not necessarily secure. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. This e-mail message is confidential and for use by the addressee only. Please notify the sender immediately by reply e-mail and delete the e-mail from your system.** If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy, or otherwise use this e-mail or its attachments. **This e-mail, including any attachments, may be confidential, privileged, or otherwise legally protected. Deep River, meanwhile, isn't working for me – the indent works to a certain depth and then all of the explicit joins are suddenly not nested any further.Ĭan anyone recommend a formatting tool/app/whatever (no, I don't have a budget for this) which will produce formatted SQL and not choke on DB2 syntax? (or maybe I should use Deep River and then work from there?) I have Data Studio 4.1.3 installed but can't currently get Visual Explain to open (separate problem), so even if DS indents text, I can't use it. It's well past the point where I can easily visualize the structures, and I've just spent an hour formatting the first about 25% of it by hand (nesting and line breaks). I'm working with a generated SQL query (COGNOS).

Sql formatter online