Problems with Illuminate Queries

Tue, 11 May 2010 12:28:47 GMT

Hi to everybody;

I have a problem linking Illuminate data base with QlikView. I can see all tables, but I can't see querys on QLikView. I use an ODBC connection.

From "illuminate Product Support" tell me that I must use CALL statment. Just like this:

{call StoredQueryName('arg1', 'arg2' ...)}
{call StoredQueryName()}
Example:
{call MySales('2006-01-30 11:10:35','2006-01-30 23:59:54')}

I have tried with these statements on QlikView Editor:
{call StoredQueryName()}
{call StoredQueryName()
SQL {call StoredQueryName()}
SQL * FROM {call StoredQueryName()}
SQL * FROM call StoredQueryName()
...
Obiously, changing the name of the query. (Case sensitive)

When I save the script and I execute a download process, it crashes.

So... How can I see the queries created on Illuminate into QlikView?

Regards,
Chema

Problems with Illuminate Queries

kji — Tue, 11 May 2010 12:47:08 GMT

QlikView sends everything after the "SQL" keyword into ODBC, however im not sure the call keyword or {} should be nescessary.

My first guess would be to use:

SQL StoredQueryName();

topic Problems with Illuminate Queries in QlikView

Problems with Illuminate Queries

Problems with Illuminate Queries