Ho to execute a Store Procedure in Qlikview

[Anonymous]

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

[ngulliver]

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

[Anonymous]

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

[ashfaq_haseeb]

Hi,

Does your SP needs any parameters?

Regards

ASHFAQ

[marcus_malinow]

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.

[maxgro]

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)

AS

BEGIN

  SET NOCOUNT ON;

  SELECT * from d001_banche where des_banca like @p_banca;

END

call in qlik

T:

load *;

sql execute sp_test '%MED%';

[Anonymous]

No

[#8]

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%;

[Anonymous]

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.