topic Re: Ho to execute a Store Procedure in Qlikview in QlikView

Ho to execute a Store Procedure in Qlikview

Anonymous — Thu, 17 Jul 2014 11:21:54 GMT

Hi all,

we tried to execute a store procedure in qlikview. it is loading properly without erros. but not even a single field is displayed after reload.

Thanks & Regards,

Siva

Re: Ho to execute a Store Procedure in Qlikview

ngulliver — Thu, 17 Jul 2014 11:53:16 GMT

Hi, Sathishkumar.

We need more information from you. I think to get a correct answer you will need to attach the app for people to check for you.

Cheers,

Neil

Re: Ho to execute a Store Procedure in Qlikview

Anonymous — Thu, 17 Jul 2014 12:01:27 GMT

hi we are not getting errors in establishing connection.Any ways if we shared the app u cant able to access the db as it is in our internal network,so we are sharing the query for your reference

SQL

exec T_Issue_History;

Thanks & regards,

Sathish

Re: Ho to execute a Store Procedure in Qlikview

ashfaq_haseeb — Thu, 17 Jul 2014 12:03:43 GMT

Hi,

Does your SP needs any parameters?

Regards

ASHFAQ

Re: Ho to execute a Store Procedure in Qlikview

marcus_malinow — Thu, 17 Jul 2014 12:07:56 GMT

It's worth clarifying here, does your stored proc return a table, or does it select one?

You may have difficulties if it's returning.

Re: Ho to execute a Store Procedure in Qlikview

maxgro — Thu, 17 Jul 2014 12:23:33 GMT

from which dbms?

some example:

from oracle

Re: Chamada de Procedure do Oracle

from sql server

procedure

CREATE PROCEDURE [dbo].[sp_test]

@p_banca varchar(10)

BEGIN

SET NOCOUNT ON;

SELECT * from d001_banche where des_banca like @p_banca;

END

call in qlik

load *;

sql execute sp_test '%MED%';

Re: Ho to execute a Store Procedure in Qlikview

Anonymous — Thu, 17 Jul 2014 12:24:27 GMT

Re: Ho to execute a Store Procedure in Qlikview

Fri, 26 Sep 2014 12:37:15 GMT

Hi Massimo,

I am following u r syntax to read my data using Store procedure.

But no data coming. Please suggest.

T:

LOAD *;

SQL execute DBANME.dbo.sp_name;

Also tried as below.

T:

LOAD *;

SQL execute DBANME.dbo.sp_name'%MED%;

Re: Ho to execute a Store Procedure in Qlikview

Anonymous — Tue, 27 Jan 2015 05:32:10 GMT

Hi, QlikView cant read data from Stored Procedure which having link to Other server, in fact QlikView will execute the Stored Procedure but it can't read data. if this is the situation thin i have a work around for this.

We have to create 2 Stored procedures to make this thing work and below are the steps.
1. Create Table in in Actual DB to hold values from Linked server.
2. Create first Stored procedures to insert data from Linked server to actual DB
3. Create Stored procedures to fetch data from Table from Actual DB
Then execute both the stored procedures sequentially in QlikView to get the result.
Since QliKView can't read data from Stored procedures having Link to other server, This might work.