Execute DB2 Proc statement

Wed, 03 Oct 2012 20:33:15 GMT

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!!!

Re: Execute DB2 Proc statement

hic — Thu, 04 Oct 2012 06:36:15 GMT

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