topic Re: How to write stored procedure in QlikView? in QlikView

How to write stored procedure in QlikView?

Sat, 19 Oct 2013 09:52:35 GMT

Friends,

Can we write stored procedure in QlikView? If then where we have to write the procedure?

And how to call the procedure from the qlikview script (OR) do we have have any other default option to do procedure.

Please help me .

Thank you,

Thiru.

Re: How to write stored procedure in QlikView?

israrkhan — Sat, 19 Oct 2013 10:01:24 GMT

Hi,

we cant write Store Procedure in qlikview, but we can execute(call)store procedure in qlik view.

how to execute ,see the link below

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

Hope it helps...

Re: How to write stored procedure in QlikView?

jagan — Sat, 19 Oct 2013 15:10:51 GMT

Hi,

Qlikview is not used to create stored procedure, it is used to fetch data from database using query or stored procedure. We can call using stored procedure like this

TableName:

Load

Field1

Field2

...

;

Sql Exec StoredProcedureName 'Variable1', 'Variable2';

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

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

Regards,

Jagan.