How to write stored procedure in QlikView?

[#1]

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.

[israrkhan]

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...

[jagan]

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.