Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

execute procedure from informix with qlikview

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.

2 Replies
Not applicable

execute procedure from informix with qlikview

sorry in QlikView does not work like this:

procedimiento:

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

erich_shiino
Honored Contributor

execute procedure from informix with qlikview

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,

Erichread and write.jpg

Community Browser