Skip to Content

Dear all,

I haven’t been able to come up with a blog on SCN now for quite some time, just because HANA really keeps me pretty busy.

Anyhow, this piece is something I already published SAP internally and since it was well liked and the work was already done, I thought: why not spend another 5 minutes and put it up to SCN? 😉

Hope you like it as well, although it really is a kind of quick’n’dirty post.
Here we go:

By chance I found out that our development colleagues now implemented the syntax assistence feature that is available in many Eclipse-based editors also in the HANA SQL- and Stored Procedure-editors.

By pressing the [CTRL]+[SPACE] keys together while your coding your SQL you get:

  • a lookup for db objects in all schemas you’ve access to (you must have typed
    in 3 characters already to have this)
  • syntax help for any SQL commands or CE_-functions
  • example statements with dummy data to demonstrate the usage of commands

This picture gives you an example of how this looks like:

/wp-content/uploads/2012/04/image_png_94684.png

Personally I totally love ➕ ➕ ➕ 😘 this little well-hidden feature and hope it serves you as well as it does serve me.

What’s also pretty cool is that you can modify the syntax help list on your own.

Just open up the preferences window and navigate to “Administration Console” – “Templates“:

/wp-content/uploads/2012/04/image_png2_94691.png

Isn’t this cool?

Cheers, Lars

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. Kumud Singh

    Hi Lars,

    Oh, this was so badly missed! Having worked on JAVA IDE’s like Eclipse, it’s actually not very pleasant to code in HANA studio without any syntax assistance. Thanking for spreading the news.

    Regards,

    Kumud

    (0) 
  2. Raj K

    Hi Lars,

    Its a super cool one 😎 i discovered late from your finest blogs.

    Really learning a lot from you.

    Regards

    Raj

    (0) 

Leave a Reply