Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Create a stored procedure in the database and use that instead?
I solved it by creating a view
thanks
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.
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.