What tool/editor you use for HANA SQL Script?

[KulDeepJain]

Hi All,

HANA Sql Script editor is not much user friendly, hope others are also having same feelings.

Can you tell me what other tools you use to edit SQL script code?

Thanks,

KD Jain

[thomas_jung]

What features would you like to see in the HANA SQLScript editor?

[rindia]

Hi Thomas,

When it comes to editing the SQLScript, I generally copy the entire code in Notepad++, do require changes and paste back the code in editor.

The features in Notepad++ gives more control on code readability.

Is it possible to have those few features in future releases?

Regards

Raj

[thomas_jung]

Well what features exactly are you looking for?  We do have code collapse, syntax highlighting, even code completion in the SQLScript editor.

[KulDeepJain]

Many like pretty printer, keyword suggestion, Blocking, tabbing... inshort which makes a developer faster to code with best practice of format.

[KulDeepJain]

Same here Raj, even I use Notepad++ for faster formatting..

[thomas_jung]

We do have Pretty Printer although in the context menu its called Format Code.

We also have keyword suggestions:

And Semantic Object Completion:

Which is why I ask specifically what features you are looking for, because several you list are already in the product.

[KulDeepJain]

When we are in Calculation view based on sqlscript screen.

Context menu only shows execute. Then I found somewhere in menu for format option. It pushes whole code to left justified.

Keyword suggestion, I should find in sqlscript Cal.View screen.

[thomas_jung]

So you are using the scripted Calculation View. That editor is quite old and no longer enhanced.  We really recommend the use of SQLScript table functions instead of the scripted calculation view in later releases.  In fact as of SPS 11 in HDI we have removed the scripted calculation view completely.  The screen shots and features I described are from the SQLScript editor itself (for procedures and functions).

[GrahamRobbo]

Multiple cursors please? Or even be able to plug-in your editor of choice?