Stored Procedure with Variables

[#1]

Hi community,

I got a stored procedure that I want to Execute and store into a CSV file.

The Stored procedure has 3 variables: StartDate, StopDate, AccountId.

Is it possible to enter these 3 variables and then Execute: GenerateFile - "stored procedure"?

[trdandamudi]

Might be the following link can help:

http://community.qlik.com/thread/3223

[fkeuroglian]

Hi Niklas

It is possible to execute a store procedure in qlikview, see this link to help you

SQL Stored Procedure into QlikView

Executing a stored procedure

https://community.qlik.com/thread/68950

You have to call the procedure and pass the parameters(values)

SQL EXEC MYPROCEDURE('VAL1','VAL2', 'VAL3')

[#4 · Accepted solution]

csv:

SQL EXEC GenerateCommciseFile

@startDate = '$(vL.startDate)',

@endDate = '$(vL.startDate)',

@accountId = null

;

STORE * FROM csv into test.csv (txt, delimiter is ',');