Advertisements

Oracle Query Hint

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!

 

Advertisements

Handy tool, Excel-SQLizer/

https://github.com/DeliciousPie/Excel-SQLizer/releases

combine NT security with user name and password #qlikview section access

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

 

Call stored procedure Oracle ODBC

Use

SQL CALL

https://community.qlikview.com/thread/12849

Oracle in OraClient 12Home2, #Qlikview, and case of field names capitalization

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

Dynamic Variable #Qlikview

set vNewVariable = $(vTestName);

let ‘$(vNewVariable)’ = ‘Something’;

RDP session for keepass

This is very nice way to add RDP sessions to keepass

http://www.nullsec.us/opening-rdp-sessions-from-keepass/