Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone please explain how to call a SQL stored procedure returning a big table of data from qlikview.
sp_text '20100101',''20100530'
This stored proc returns all data for all employees in the given date range, I want to capture all that data and display it in charts & tables in qlikview
I am struggling with the exact syntax of how to make this call & capture the resultset ?
Amit
Your command should look like this:
SQL EXEC sp_text '20100101','20100530';
If you are loading the resultset into a table, something like this:
qvw_table_name:
LOAD *;
SQL EXEC sp_text '20100101','20100530';
Hope it helps
Your command should look like this:
SQL EXEC sp_text '20100101','20100530';
If you are loading the resultset into a table, something like this:
qvw_table_name:
LOAD *;
SQL EXEC sp_text '20100101','20100530';
Hope it helps
Awesome ... Thanks a ton!!!
Hi Amit,
Cold you share the exact script which you using to run the SQL Stored Procedure
Hi Amit,
Cold you share the exact script which you using to run the SQL Stored Procedure
XYZ_mis:
LOAD *;
SQL EXEC SP_abc 20100523,$(TODAY),'mycompany';
I am getting an OLEDB error
OLEDB read failed
SQL EXEC sp_xyz
I think this might be something to do with the connection mode, My stored procedure writes data in the database and i read somewhere that we need to add "mode is write" at the end of the connection string
I have done that but it still giving me the same error !
I am able to execute the stored procs which are simple reads with no temp tables
Anyone knws how to sort this out ??