Author Topic: DB function as metadata?  (Read 370 times)

Offline James111

  • Full Member
  • ***
  • Posts: 10
  • Forum Citizenship: +0/-0
DB function as metadata?
« on: 02 Sep 2010 06:39:45 pm »
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!

Offline peritas-chris

  • Full Member
  • ***
  • Posts: 45
  • Forum Citizenship: +3/-0
Re: DB function as metadata?
« Reply #1 on: 04 Sep 2010 11: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
Chris F
Peritas