Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fabio
Contributor III
Contributor III

Qlikview & DB2 Temporary Table

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!

4 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
fabio
Contributor III
Contributor III
Author

I solved it by creating a view


thanks

carlcimino
Creator II
Creator II

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.

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand