At 04:39 PM 2/20/2001 -0300, Carlos H. Cantu wrote:

>Yeh Ann, I though about that too, but I think he wants a more "flexible"
>way where he dont need to specify the children table(s). Maybe using the
>system tables to retrieve the relations, but I dont know if this could be
>done in a single SQL (???)

I think it can't. Even doing very dynamic query generation, you'd
need to retrieve metadata before generating the query. I could do
it (sort of) in QLI by creating a procedure (QLI style, not a stored
procedure) that writes a file and then executes that file.


Regards,

Ann
www.ibphoenix.com
We have answers.