Execute DB2 Proc statement

[#1]

It seems that it should only be a one-liner to create a statement to run a DB2 procedure called JBRAT00.FO_P.

Has a bunch of SQLs and SAVE DATA AS in it.  JBRAT00 is the Owner.

Can someone tell me the exact statement after the ODBC CONNECT statement?

Thanks!!!

[hic]

First, you will need to add the parameter "mode is write" in the ODBC/OLEDB-connection:

CONNECT TO <connection_string> (mode is write);

Secondly, you need to activate "Open Databases in Read and Write mode" in QlikView. This is done in the script editor on the tab "Settings".

Then you can use

SQL EXECUTE <stored_procedure> ;

HIC