topic Re: Stored Procedure with Variables in QlikView

Stored Procedure with Variables

Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 18 Aug 2016 11:24:17 GMT

Might be the following link can help:

fkeuroglian — Thu, 18 Aug 2016 11:26:37 GMT

Hi Niklas

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

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

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

Thu, 18 Aug 2016 11:32:21 GMT

csv:

SQL EXEC GenerateCommciseFile

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

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

@accountId = null

;

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