Discussion Board for collaboration on QlikView Scripting.
I need to run a stored procedure from the Informix database, Informix I run as follows: sp_librobco execute procedure (mdy (05,01,2011), MDY (05,31,2011), 71839, 71839, 3) and QlikView does not work like this: procedure: execute sql sp_librobco '05-01-2011 ', '05-05-2011', 71839, 71839, 3; What is the correct way to run it Thank you.
sorry in QlikView does not work like this:
sql execute sp_librobco '05-01-2011', '05-05-2011', 71839, 71839, 3;
If this procedure writes in the database, you need to see QlikView to have a read and write connections on the database.
You need to include the text 'mode is write' at the end of your connections string.
You also need to set QlikView to read and write mode at the script editor (please check image on the post)
Hope this helps,