Re: Recursive Query

Raj Pratha <raj> wrote: >Is it possible to write a stored procedure that could be used to select all the >children records of a given parent record, where the both the children and >parent records are stored in the same table. That is the table has a one to >many relationship to itself. > >I have seen examples of this type of resursion in Informix 4GL but not in >stored procedurs. Thank you for your information. I've never tried this, however, I believe stored procedures can be recursive. Where do you want to store the results? If in a temporary table, you may run into a problem of "insert into/select from" on the same table not being allowed. I guess I'm not sure, but it sure seems like it should be possible. If you succeed, let us know how you did it. Roger Tomas AG Communication Systems