Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

siva_boggarapu
Contributor II

STORED Procedure

Hello,

How to call stored Procedure from SQL Server  into QlikView script.

1 Reply
erich_shiino
Honored Contributor

STORED Procedure

Hi,

I depends on the type of stored procedure you have.

Do you want to just execute a command on the DB, return a value or return a table?

This thread discuss this.

http://community.qlik.com/message/38960#38960

Of course, the user calling the connnection must have enough rights to execute it and if it change the DB you need the mode is write tag on the connection string and open the db in read and write mode.

Regards,

Erich