topic Re: NLS language setting in Qlikview in QlikView

NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 08:21:33 GMT

Hi All,

I'm reading data from oracle view and below is the connection details in edit script.

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxexerp;Data Source=ebs;Extended Properties=""] (XPassword is QZCTFcBPFDeKGZBOIB);

sql alter session set nls_language = 'AMERICAN';

SQL SELECT *

FROM APPS."XXEGC_QV_SALES_ORDER_V";

The view executes fine but won't get any data if i comment sql alter session set nls_language = 'AMERICAN';

Instead of writing the alter session statement in Qlikview edit script, is there any option in Qlikview where i can set this for one time.

Thank you.

Regards,

Viresh

Re: NLS language setting in Qlikview

Anil_Babu_Samineni — Tue, 12 Dec 2017 08:55:50 GMT

May be change your QlikView environment

SET Language = 'US-ENG' to 'AMERICAN' ..

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 09:17:54 GMT

Hi, no changes.

Re: NLS language setting in Qlikview

Anil_Babu_Samineni — Tue, 12 Dec 2017 09:20:13 GMT

Where do you change, can you show image?

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 09:23:47 GMT

Hi, i made the changes in the main edit script window where we have other variables set.

Re: NLS language setting in Qlikview

Anil_Babu_Samineni — Tue, 12 Dec 2017 09:35:20 GMT

Is that is the same https://community.qlik.com/message/1399433

Can you share DM?? Does this schema formed at least?

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 09:37:17 GMT

Hi, yes it is the same post.

What is DM? sorry

Re: NLS language setting in Qlikview

Anil_Babu_Samineni — Tue, 12 Dec 2017 09:39:10 GMT

can you check Ctrl + T? Does it showing anything?

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 09:39:55 GMT

DM- data model?

I am trying load a single view. Currently i don't have data model.

The same query will work without any issue in another qlikview environment.

thanks

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 09:43:48 GMT

Hi,

If i remove the set nls_language statement and reload the application, it will reload without any error but there won't be any records available. The table viewer shows the single table but can't preview as there is no data in that table.

Thanks

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 09:45:36 GMT

The log file says xx fields found, 0 lines fetched.

Re: NLS language setting in Qlikview

Anil_Babu_Samineni — Tue, 12 Dec 2017 09:46:06 GMT

Great, What does that condition indicates? sql alter session set nls_language = 'AMERICAN';

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 09:50:05 GMT

Hi, Initially i was not getting any records in SQL Developer as well. Then i did some research in net and changesd the NLS (National language support) language option in SQL developer. The query was able to fetch the records.

I used the same statement in Qlikview edit script after the connection string and i am able to get records.

Thanks

Re: NLS language setting in Qlikview

Anil_Babu_Samineni — Tue, 12 Dec 2017 09:55:33 GMT

For a while do this?

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=xxexerp;Data Source=ebs;Extended Properties=""] (XPassword is QZCTFcBPFDeKGZBOIB);

SELECT SQL alter session set nls_language = 'AMERICAN';

SQL SELECT *

FROM APPS."XXEGC_QV_SALES_ORDER_V";

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 10:00:23 GMT

Hi, yes this is for time being. I am looking if there are any other options.

By the way we need to remove the select word before the SQL alter session set nls_language = 'AMERICAN';

before we execute the reload.

Regards,

Viresh

Re: NLS language setting in Qlikview

Anil_Babu_Samineni — Tue, 12 Dec 2017 10:03:33 GMT

Yes, I even wonder there is alternate for within Qlikview. Below one works as expected. Aren't you?

SQL alter session set nls_language = 'AMERICAN';

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 10:04:53 GMT

Yes it is working fine.

Re: NLS language setting in Qlikview

Anil_Babu_Samineni — Tue, 12 Dec 2017 10:07:19 GMT

Okay, Please close this thread

Re: NLS language setting in Qlikview

Or — Tue, 12 Dec 2017 10:28:33 GMT

As far as I know, there's no way you can have QlikView set default database-specific parameters.

You could change the machine's default NLS_LANG, which should apply to QlikView as well:

Configuration Parameters and the Registry‌

And while I realize this isn't helpful to you, I'd consider having words with whoever wrote that view - it sounds like they've hard-coded information in a format that is specific to one locale, which is almost never a good idea.

Re: NLS language setting in Qlikview

vireshkolagimat — Tue, 12 Dec 2017 10:33:25 GMT

Hi,

while there are certain views which execute without any modifications. I am facing this issue only with certain views.

thanks for your suggestion and will have a word with the person who built these views.

Regards,

Viresh