View Single Post

   
  #3 (permalink)  
Old 02-27-2008, 07:14 AM
P. Adhia
 
Posts: n/a
Default Re: How to convert a stored-proc with one result-set into a table udf

4.spam@mail.ru wrote:
> You have to use external udf (c, java for example) to do this.


Thanks for the response. It isn't as easy as I thought it would be.

I guess my next best option is to write queries against catalog tables.
Just so that I don't reinvent the wheel, has anyone attempted to create
views (or set of queries) on catalog tables that mimic the result-sets
returned by reorgchk_tb_stats and reorgchk_ix_stats?

Thanks again

P Adhia

Reply With Quote