Print Page - DB function as metadata?

Title: DB function as metadata?
Post by: James111 on 02 Sep 2010 07:39:45 AM

Hi there,
I have a stored function in my DB which returns a ref cursor.
I want to use the result as my metadata in my Framework Manager model.

How can I do that?

Thanks!

Title: Re: DB function as metadata?
Post by: peritas-chris on 04 Sep 2010 12:28:43 PM

You should be able to use it, just call it via SQL in your select statement.

For example:

Select *, dbo.YourFunction(parameter) as FunctionResults
from TableA

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: James111 on 02 Sep 2010 07:39:45 AM