Posted on August 2, 2019 by mellerbeck
https://boristyukin.com/qlikview-and-oracle-database-tips-for-performance/
Normally Oracle query hints will be written using /*+ ... */syntax. One day I spent many hours trying to figure out why one of my queries took forever to finish if I ran it from QlikView and took only a minute if I ran it from Oracle SQL Developer. Turned out that QlikView by default would strip out comments from SQL statement and treat /*+ ... */ as a comment.
This “feature” is discussed here.
Solution is easy – just use –+ syntax instead if you need to pass a query hint. Of course it is a very easy thing to forget!
Filed under: Uncategorized | Leave a comment »
Posted on May 7, 2018 by mellerbeck
Posted on April 27, 2018 by mellerbeck
The trick is in the *
You can add reducing fields after the NTNAME
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, NTNAME
ADMIN, ADMIN, welcome, *
USER, *, *, DOMAIN\USERNAME
];
Section Application;
From https://community.qlik.com/thread/29846
Filed under: Uncategorized | Leave a comment »
Posted on April 26, 2018 by mellerbeck
Posted on April 26, 2018 by mellerbeck
This was an annoying one for a bit.
Say you have this Qlikview script
LOAD
Sales_Order
;
Select ORDER_NUMBER as Sales_Order from…. ;
Well, it won’t work because the Oracle ODBC driver uppers all the returned field names, or Oracle does? Who knows?
Anyways, to make it work
LOAD
SALES_ORDER
Filed under: Uncategorized | Leave a comment »
Posted on April 16, 2018 by mellerbeck
set vNewVariable = $(vTestName);
let ‘$(vNewVariable)’ = ‘Something’;
Filed under: Uncategorized | Leave a comment »
Posted on March 21, 2018 by mellerbeck
