Using Informix stored procedure in SQL Table in Report Studio

[cfortiz]

Hi everyone.

I have need to run a report which is taking forever to run on Report Studio.  In order to improve performance, I have created stored procedure which feeds off two parameters.  In particular, this is an Informix stored procedure using the return with resume feature.

I have tried to add the stored procedure to the SQL Table with no avail.  Is it even possible to do this through the SQL Table interface?  This procedure has both in and out parameters.

Thanks in advance.

- Carlos

[goose]

Hi Carlos

You should add the stored procedure to a Framework Manager model and use that that way it will be best.

Cheers
Angus