topic SQL Stored Procedures ---Format in QlikView

SQL Stored Procedures ---Format

Thu, 04 Oct 2012 18:55:59 GMT

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.

Re: SQL Stored Procedures ---Format

hic — Fri, 05 Oct 2012 11:38:14 GMT

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