Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

Is it possible to auto-format the sql code when copy-pasted into Interactive SQL?

asked 09 Oct '15, 05:46

tzup's gravatar image

accept rate: 0%

I know of a few editors out there that do parse and format SQL ... with mixed results from my experience ... but I am still looking for one with a complete set of features for this myself. So do share if you have had good experiences there yourself.

But there are a few SQL Central and DBISQL features that you might find helpful.

The Editor in DBISQL has a number of options around formatting that can be useful. You can tell the editor how to treat tabbing, indentation (automatic and style), and make 'text completion' do a number of useful things. The same is true for SQL Central, when editting procedures/views/functions/events, you can make these changes to the editor there (see Customize Editor).

On an individual statement basis, the Query Editor will take individual queries and block out the separate clauses for you to some extent.

I have found the "Translate to Watcom-SQL" SQL Central's editor feature somewhat helpful in this regard too (for PSM language objects at least) but I miss that as a immediate feature in DBISQL. {though you can call the underlying WATCOMSQL( sql-statement-string ) system function if you want to brave passing your .SQL scripts through that)

But a full and proper SQL Pretty Printer (as this type of facility was once known as), alas, we are lacking that feature currently.

permanent link

answered 09 Oct '15, 09:52

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
accept rate: 32%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 09 Oct '15, 05:46

question was seen: 1,995 times

last updated: 09 Oct '15, 09:52