topic Executing Stored Procedure in QlikView

Executing Stored Procedure

Wed, 29 Jun 2016 12:15:35 GMT

Hi All,

I have attached the sample of Stored procedure. Could you please tell me how to execute that SP in Qlik?

Thanks

Re: Executing Stored Procedure

Wed, 29 Jun 2016 13:17:18 GMT

To execute SQL stored procs in QV load script you will use SQL EXEC.... for example SQL EXEC ProcedureName

Re: Executing Stored Procedure

Wed, 29 Jun 2016 13:34:33 GMT

Hi,

Thanks for your reply. I know that I need to use SQL EXEC. But I am struggling to add Parameters and Variables that are in my script. Please see the attached in my first post above. In the SP there are 3 parameters and almost 11 variables in there.

Could you please tell me how to add those parameters and variables in qlikview?

Thanks

Re: Executing Stored Procedure

Thu, 30 Jun 2016 08:12:34 GMT

Can anyone help me on this?

Re: Executing Stored Procedure

Peter_Cammaert — Thu, 30 Jun 2016 12:15:31 GMT

The SQL EXEC statement is a SQL statement. This statement including any (optional) parameters is passed as-is to the Database engine. Your RDBMS documentation should contain information on how to pass additional info to the Stored Procedure.

For example, MS SQL Server accepts a statement like:

SQL EXEC [StoredProcedureName] 'LiteralParm1', '$(vLiteralParm2)', $(vNumericParm3);

$-sign substitution is used to make sure the placeholders are replaced with real values and under control of QlikView script. Variables can be used by first declaring them. See also here: SQL Stored Procedure into QlikView

Best,

Peter

Re: Executing Stored Procedure

Peter_Cammaert — Thu, 30 Jun 2016 12:16:54 GMT

Note that I came to the highly enlightening post by Johannes Sunden by doing a 5-minute search of the community. You should try it.

Best,

Peter

Re: Executing Stored Procedure

rustyfishbones — Sun, 19 Feb 2017 23:23:53 GMT

Or try this video

Qlikview EXECUTE SQL Stored PROC with Parameters in Qlikview by RFB 228 - YouTube

Re: Executing Stored Procedure

rustyfishbones — Sun, 19 Feb 2017 23:24:19 GMT

Try this

Qlikview EXECUTE SQL Stored PROC with Parameters in Qlikview by RFB 228 - YouTube