Skip to Content

How to apply banner in HDBSQL?

Oct 31, 2017 at 02:12 PM


avatar image
Former Member

Hi Gurus :-)

Could you please tell me a way so as to update my hdbsql prompt with a banner. For example, the current format of the prompt is "hdbsql=>" for a HANA SID let's say HDB.

Can it be updated to something like "hdbsql[PRODUCTION:HDB]=>" ?

Doing this could be useful if we are installing multiple databases on the same underlying host(although we can differentiate by the OS user using which we logon to hdbsql, its very clear if the prompt is updated, because each time someone executes something, they're aware of the environment).

Also the welcome banner says "Welcome to the SAP HANA Database interactive terminal." when we logon to hdbsql. Is there a way in which we can add text to the welcome banner(for ex, warning the user that the sql prompt is for a production database)? The thought arises because we get a warning message in HANA studio if the system is tagged as PRODUCTION, so would be great to update the display in HDBSQL too.

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Lars Breddemann
Oct 31, 2017 at 10:33 PM

HDBSQL doesn't offer configurable banners.

Usually, I would recommend to bring up this idea in the idea-place but as of now the replacement solution for idea place seems unusable to me, so I cannot recommend it.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Lars,

Is it possible to recommend it in the idea place now(if the tool is ready) ?



I really don't know (or care) about the state of the tool. If it works for you, then go ahead and enter your improvement idea. If I'm not mistaken this is the link for the HANA Platform campaign.