Text Join returning null values in SAP HANA Web Workbench while giving desired output in Eclipse

[former_member208449]

Hello Community

I have created a calculation view with text join between two tables.

The output of the view on SAP HANA Web Workbench -

The output of the view on Eclipse -

The HANA server is on cloud(SPS11) and I have added the same in Eclipse.

Kindly respond regarding the possibilities for the same.

[lbreddemann · Accepted solution]

shot into the blue: the LOCALE/SAP_LOCALE Session context variable is not set in the Web workbench, so the Text join doesn't find any matching records...!?

[former_member208449 · Accepted solution]

Hello Lars

Could you please let me know where I can set the same. I took a rough tour of the work bench editor and I couldn't find any setting corresponding to the same.

[lbreddemann · Accepted solution]

You can try to use

SET LOCALE='EN'; 

in the console you're using to test the query.

Alternatively, there is a user parameter for the locale, that would be used (if set) when the client software doesn't set it.

ALTER USER <user_name> SET PARAMETER LOCALE='EN';

should do the trick.

[former_member208449 · Accepted solution]

Hi Lars

I added the LOCALE='EN'parameter to the user which I am using to logon.

Even then, I am getting null values for the text join in the HANA workbench. Please help me on the same.

[lbreddemann · Accepted solution]

Ok, then how about you logon to the SQL console and check whether the parameter is actually set?

SELECT session_context('LOCALE') from dummy;

[former_member208449 · Accepted solution]

Hi Lars

I am able to get the result as 'en' upon executing the above SQL. Also, I don't know what went wrong, now I am able to see the data.

Thanks Lars 🙂

[FCI]

What language are you using for your internet browser ? This is probably not the same than the one you use for the Studio.

Regards,

Frederic

[former_member208449]

Hi

It's the same language which is being used in both Studio and browser.