Qlikview & DB2 Temporary Table

[fabio]

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!

[Gysbert_Wassenaar]

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

[fabio]

I solved it by creating a view

thanks

[carlcimino]

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.