Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to execute stored procedure in qvw file and pass selected date as a parameter to that storded procedure
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,
SQL EXECUTE ProcName 'param1', 'param2';