Change Log In User's LOCALE through SQL
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,
Lars Breddemann replied
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.