SQL Stored Procedures ---Format

[#1]

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.

[hic]

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