Re: Informix Stored Procedures with Cognos Impromptu Report Writer
Hi Joyce.
This can be done, but only by pasting SQL directly into Impromptu.
I am using Administrator Version 7.1.339.0 and IDS 9.30 on HP-UX.
To provide a clear example, I created the following procedure:
CREATE PROCEDURE sp_resume_test(search CHAR(30))
RETURNING CHAR(8), CHAR(30);
DEFINE login CHAR(8);
DEFINE full_name CHAR(30);
FOREACH WITH HOLD
SELECT user_name, user_full_name
INTO login, full_name
FROM t_user
WHERE user_name MATCHES search
OR user_full_name MATCHES search
RETURN login, full_name WITH RESUME;
END FOREACH
END PROCEDURE;
After opening Impromptu in Windows XP, I then did:
1) Catalog / Open
2) File / New / Simple List
3) Profile / SQL / Edit
4) Entered "EXECUTE PROCEDURE sp_resume_test()"
5) Placed the cursor between the brackets
6) Clicked on "Insert Prompt"
7) Entered "Search" in "Name"
8) Entered "Match on login or user name (* wildcard)" in "Message"
9) Clicked on "OK" 3 times
Regards,
Doug Lawry
www.douglawry.webhop.org
"Joyce" <jridgley@beverlyhills.org> wrote in message
news:8f5d565f.0311260728.d2b7345@posting.google.com...
> I would like to retrieve multiple Informix Database records using a
> stored procedure and use these records in a 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.