How to apply banner in HDBSQL?

[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.

[lbreddemann]

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.

[Former Member]

Hi Lars,

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

Thanks.

[lbreddemann]

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 https://influence.sap.com/sap/ino/#campaign/902 is the link for the HANA Platform campaign.