topic execute procedure from informix with qlikview in QlikView

execute procedure from informix with qlikview

Wed, 15 Jun 2011 20:10:32 GMT

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.

execute procedure from informix with qlikview

Wed, 15 Jun 2011 20:12:08 GMT

sorry in QlikView does not work like this:

procedimiento:

sql execute sp_librobco '05-01-2011', '05-05-2011', 71839, 71839, 3;

execute procedure from informix with qlikview

erichshiino — Fri, 17 Jun 2011 02:15:21 GMT

Hi,

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,

Erich