Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

sorry in QlikView does not work like this:

procedimiento:

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

erichshiino
Partner - Master
Partner - Master

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