Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Change Log In User's LOCALE through SQL

Hi Experts,

Could you please let us know if there is a way we can set the LOCALE of the user logging into HANA Studio through SQL?

We are able to set by right clicking the System --> Properties --> Additional Properties, but we will like to achieve this through SQL.

We tried to Set Session 'LOCALE' = 'EN'  and Update value in m_session_context table with no success,

Thanks and Regards,

Ram

Tags:
replied

Hi Ram

your problem is not that you cannot set the the session locale settings after the logon, but rather how the language lookup should handle non-matches and what fall-back output should be provided.

Currently SAP HANAs text join does not provide a fall-back language for incomplete data sets.

If the data is not maintained in the language that was set, then the result will be NULL.

Using a manual filter on the language denoting column is fine - really, the text join is a simplification for the modeler. Technically it doesn't do anything else then a normal join.

- Lars

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question