Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vireshkolagimat
Creator III
Creator III

NLS language setting in Qlikview

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


19 Replies
vireshkolagimat
Creator III
Creator III
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vireshkolagimat
Creator III
Creator III
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vireshkolagimat
Creator III
Creator III
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vireshkolagimat
Creator III
Creator III
Author

Yes it is working fine.

Anil_Babu_Samineni

Okay, Please close this thread

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Or
MVP
MVP

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
Creator III
Creator III
Author

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