how to call stored procedure and pass parameter as a selected date

[#1]

Hi,

How to execute stored procedure in qvw file and  pass selected date as a parameter to that storded procedure

Administrator

[jaimeaguilar]

Hi,

you can follow this syntax:

first you have to create a variable for each parameter you need to pass to the Store Procedure. In this example, let's suppose you just have a single date parameter:

let vDate = '2013-01-01' //here is important to use the same format that is used in the database

Store_Procedure_table:

Load * ;

SQL EXECUTE DB.OWNER.STORE_PROCEDURE '$(vDate)'; //with the last part you're passing the needed parameter

If you had several parameters you can separate them with commas and alwas with the $-expansion and between single quotes,

regards,

[Clever_Anjos]

SQL EXECUTE ProcName 'param1', 'param2';