Qlik Sense 3.2 - how to call a DB2 stored procedure

[nathan_beene]

Hello all,

We have the syntax down for calling a SQL stored procedure, but are having trouble with the syntax for calling a DB2 stored procedure.  Is this native to Qlik to call a DB2 stored procedure?  We can execute a DB2 query from the data load editor, so our ODBC connector is working, but we cannot get the syntax right for calling a DB2 stored procedure.  Any help appreciated.

Using 3.2 Enterprise edition.

[devarasu07]

Hi,

I haven't tried with DB2 DSN , but tested below SQL server - Stored procedure and it's working fine in qlik sense 3.2. try to do same way for  db2 connection string and let us know if any issue. Tks

try like below,

LIB CONNECT TO 'BI_WHS';

Students:

load *;

SQL exec dbo.Students;

Store * from Students into 'lib://QVD/Students.qvd';

Execute a Stored Procedure in Qlik Sense

ThankS

Deva

[nathan_beene]

Thanks Devarasu.  We can run a SQL store procedure successfully with that syntax - the issue occurs when we try the same with DB2:

When using OLE

No error is returned simply no row set is returned as well

When using an ODBC connection the error is

Started loading data

Connecting to DEV DB2 () Connected

The following error occurred:

Error: File extdata.cpp, Line 2326

The error occurred here:

SQL CALL DB2SERVERNAME.DBLIBRARY.QLIK_TEST()