NLS language setting in Qlikview

[vireshkolagimat]

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

[vireshkolagimat]

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

[Anil_Babu_Samineni]

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

[vireshkolagimat · Accepted solution]

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

[Anil_Babu_Samineni]

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";

[vireshkolagimat]

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

[Anil_Babu_Samineni]

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';

[vireshkolagimat]

Yes it is working fine.

[Anil_Babu_Samineni]

Okay, Please close this thread

[Or]

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.

[vireshkolagimat]

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