topic Qlikview & DB2 Temporary Table in QlikView

Qlikview & DB2 Temporary Table

fabio — Wed, 08 Oct 2014 13:54:29 GMT

My SQL SELECT contains a WITH statement. It create a temporary table for a recursive query (a Bill of Materials). the query it's ok!

The problem is the qlikview script don't know the WITH statement.

Qlik not simply send the query to db2 😞

Any idea?!?

thanks!

Re: Qlikview & DB2 Temporary Table

Gysbert_Wassenaar — Wed, 08 Oct 2014 14:07:23 GMT

Create a stored procedure in the database and use that instead?

Re: Qlikview & DB2 Temporary Table

fabio — Wed, 08 Oct 2014 15:46:32 GMT

I solved it by creating a view

thanks

Re: Qlikview & DB2 Temporary Table

carlcimino — Wed, 08 Mar 2017 15:42:29 GMT

What if you don't have permissions to write in the DB? In WINSql I can use the With statement when querying a DB2 data source; in QlikView I cannot use the with statement. I'm working around it by creating temp tables in Qlik and joining them after the fact but it seems inefficient.

Re: Qlikview & DB2 Temporary Table

Gysbert_Wassenaar — Thu, 09 Mar 2017 16:22:08 GMT

Perhaps you can rewrite the sql statement so it doesn't use a with block. Or perhaps you have a friendly local DBA that is willing to create a view for you.