Solved: NLS language setting in Qlikview - Qlik Community

vireshkolagimat · ‎2017-12-12

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 · ‎2017-12-12

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

View solution in original post

Anil_Babu_Samineni · ‎2017-12-12

May be change your QlikView environment

SET Language = 'US-ENG' to '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 · ‎2017-12-12

Hi, no changes.

Anil_Babu_Samineni · ‎2017-12-12

Where do you change, can you show image?

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 · ‎2017-12-12

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

Anil_Babu_Samineni · ‎2017-12-12

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

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

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 · ‎2017-12-12

Hi, yes it is the same post.

What is DM? sorry

Anil_Babu_Samineni · ‎2017-12-12

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

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 · ‎2017-12-12

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

vireshkolagimat · ‎2017-12-12

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