db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vrin26 <divi.markapu...@in.ibm.com>
Subject Re: Recursive query on common table
Date Thu, 15 Oct 2009 11:33:50 GMT

Hi,
Can any one help me with an idea, how I can do  a recursion for this issue. 
Thanks.


Rick Hillegas-2 wrote:
> 
> Vrin26 wrote:
>> Hi,
>>
>> I need to do a recursive query on a single derby database table.
>> In Derby database documents it is mentioned that this derby doesn't
>> support
>> recursive queries.
>> Is there any other work around to handle this scenario?
>>
>> Thanks
>>
>>   
> You can push the recursion into a table function or into a database 
> procedure which returns a result set. The table function documentation 
> talks about wrapping external data sources, but you can also use table 
> functions to wrap complicated processing inside Derby itself. See 
> http://db.apache.org/derby/docs/10.5/devguide/devguide-single.html#cdevspecialtabfuncs

> The CREATE PROCEDURE statement is documented here: 
> http://db.apache.org/derby/docs/10.5/ref/ref-single.html#crefsqlj95081
> 
> Hope this helps,
> -Rick
> 
> 

-- 
View this message in context: http://www.nabble.com/Recursive-query-on-common-table-tp25819772p25906990.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message