How do I execute an informix stored procedure using msaccess

[mictip]

I use MSAccess to link to an informix db to run reports I create for the users who are given user logins to the informix db. I am not a programmer but can write basic SQL statements. I created an MSAccess query that has a number of parameters - some user input (from/to date) and some fixed. The fixed ones go against columns that are not indexed and it takes a long long time to run so the DBA is asking if I am able to execute a stored procedure in informix from within MSAccess. I have never done this and do not know where to start. Is this something I can do if he gives me the name of the stored procedure? I want to extract the data and create a report that displays it when the users run the report and input the date parameters...help!

 

[Doug Lawry]

If you can't execute an Informix procedure directly, use the following trick:

SELECT * FROM TABLE(FUNCTION procedure(parameters)) AS alias (columns)

Regards,
Doug Lawry
Oninit Consulting
oninitgroup.com