Can i use connect by prior in IDS Select query?

Hi, I am very new to informix, wants to know dose the connect by prior clause will work with IDS. if not then is there anything similar to that. Regards, Ashish

Ashish Singhal said: > > I am very new to informix, wants to know dose the connect by prior clause > will work with IDS. No. > if not then is there anything similar to that. Depends on your version. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Thanx for your early response, I am using IDS 10.0 what is available similar to connect by prior in this version. Regards, Ashish "Obnoxio The Clown" <obnoxio@serendipita.com> wrote in message news:mailman.652.1178872956.10648.informix-list@iiug.org... Ashish Singhal said: > > I am very new to informix, wants to know dose the connect by prior clause > will work with IDS. No. > if not then is there anything similar to that. Depends on your version. -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.

Ashish Singhal said: > Thanx for your early response, > > I am using IDS 10.0 what is available similar to connect by prior in this > version. http://www-128.ibm.com/developerworks/db2/zones/informix/library/techarticle/db_node.html -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.