Re: Recursive Query

YES you can. I have done this with a single SPL. Just make sure there is a return value for no data so that the end of a branch can be identified. rmcall@on-ramp.ior.com Roger Tomas <tomasr@agcs.com> wrote: >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