Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nathan_beene
New Contributor

Qlik Sense 3.2 - how to call a DB2 stored procedure

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.

Tags (2)
2 Replies
devarasu07
Honored Contributor II

Re: Qlik Sense 3.2 - how to call a DB2 stored procedure

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
New Contributor

Re: Qlik Sense 3.2 - how to call a DB2 stored procedure

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()

 

Community Browser