Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
When I run my procedure, I'm not getting any messages.
My stored procedure creates a table in DB2 by running 2 sqls. My stored proc (ABC.P) is
RU ABC.QUERY1
SAVE DATA AS ABC.T1 (NO CONFIRM
RU ABC.QUERY2
SAVE DATA AS ABC.T1 (APPEND
I'm running in Script:
connect to DB2P (mode is write);
DB2_T1:
load *;
SQL exec ABC.P ;
exit script;
No table called ABC.T1 is produced.
First, there is an additional security check box at the bottom of the script editor - Settings tab - "Open databases in read and write mode". Then it should work.
However, QlikView sends everything found between the "SQL" and the semicolon to the ODBC so it all depends on which syntax it accepts. I have seen both "EXEC" and "EXECUTE"; I have seen cases where you need to put quotes around the SP name.
Finally, you may also need to check that you have rights on the DB to run the stored procedures this way.
HIC