Skip to Content
Technical Articles
Author's profile photo Jonathan Bregler

What’s New in the SAP HANA Database Explorer Visual Studio Code Extension Version 1.6

Earlier this year the first version of the SAP HANA Database Explorer Visual Studio Code extension was released to the Visual Studio Code marketplace.

You can find the features introduced in previous versions in my other blog posts.

What’s New?

This week, version 1.6 of the extension has been released to the Visual Studio Code marketplace. In addition to some bug fixing and general improvements, the new version brings several noteworthy features.

Parameterized Statements

The SQL console can execute statements with parameters. When a statement with parameters is encountered, a new tab is shown that allows the user to enter the parameter values and then execute the parameterized statement.

 

Connection Auto-commit Setting

The current connection’s auto-commit state can be set from the SQL console via an icon in the menu bar.

 

CREATE Statement Generation

A CREATE statement can be generated for database objects via the context menu of the database objects in the catalog browser. By default the CREATE statement will be opened in a new SQL console. As an additional option the CREATE statement can also be copied to the clipboard.

 

Copy Object Names

The name and full name (schema + object name) of database objects can be copied to the clipboard via the context menu of the database objects in the catalog browser.

 

SQL Console Font Size

The SQL console font size can now be changed via the Visual Studio Code setting “Editor: Font Size”.

 


Stay tuned for more exciting new features in future releases!

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Amit N Kulkarni
      Amit N Kulkarni
      • can have feature the store sql require or from sap notes 1969700 and run them by searching .
      • can have feature to generate  planviz and trace analyzer features
      Author's profile photo Jonathan Bregler
      Jonathan Bregler
      Blog Post Author

      Hi Amit,

      Thanks for your suggestions. We'll take them into consideration for a future version of the extension.

      Best regards,

      Jonathan

      Author's profile photo Song Zhi Chong
      Song Zhi Chong

      Nice extension. I use it now in my work.

      If there are  several fuctions in futhure, I think it will be perfect!

      1 Edit store procdure and function

      2 Format code like abap pretty print

      3 Debug store procdure and function

       

       

      Author's profile photo Jonathan Bregler
      Jonathan Bregler
      Blog Post Author

      Thanks for your suggestions. We'll take them into consideration for a future version of the extension.

      If you have additional ideas for improving the extension please let us know.

      Best regards,

      Jonathan

      Author's profile photo Shamshir Khakimov
      Shamshir Khakimov

      Is it possible to specify blank value for parameters?

      Author's profile photo Jonathan Bregler
      Jonathan Bregler
      Blog Post Author

      Hi Shamshir,

      yes, you can specify blank value for parameters.

      Best regards,

      Jonathan