Print Page - Using Informix stored procedure in SQL Table in Report Studio

Title: Using Informix stored procedure in SQL Table in Report Studio
Post by: cfortiz on 18 Aug 2008 09:56:53 AM

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

Title: Re: Using Informix stored procedure in SQL Table in Report Studio
Post by: goose on 19 Aug 2008 08:37:37 AM

Hi Carlos

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

Cheers
Angus

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: cfortiz on 18 Aug 2008 09:56:53 AM