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:
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“:
Isn’t this cool?