Informix Stored Procedures with Cognos Impromptu Report Writer

Posted in 2003

Joyce — 26 Nov 2003 07:28:17 -0800 — source: Usenet: comp.databases.informix

I would like to retrieve multiple Informix Database records using a stored procedure and use these records in an Cognos Impromptu Report. I have a stored procedure that returns all values for one row now. I am working on HP UX platform for the database and Microsoft Windows XP with Cognos Impromptu 7.1.

↪ replying to Joyce

Fernando Nunes — Wed, 26 Nov 2003 17:09:54 +0000 — source: Usenet: comp.databases.informix

Joyce wrote: > I would like to retrieve multiple Informix Database records using a > stored procedure and use these records in an Cognos Impromptu Report. > I have a stored procedure that returns all values for one row now. I > am working on HP UX platform for the database and Microsoft Windows XP > with Cognos Impromptu 7.1. Use "RETURN [...] WITH RESUME". It's documented in SQL Syntax Guide and there is some more info in SQL Tutorial guide (including examples). Regards.