Oninit cdi / Archive
Talk to an expert →

Can i use connect by prior in IDS Select query?

Posted in 2007

Summary

Ashish Singhal asked whether CONNECT BY PRIOR works in IDS or what is similar, saying he used IDS 10.0. Obnoxio The Clown first answered No, noting it depends on the version, then pointed to an IBM developerWorks article about tree/node handling as the alternative. No further discussion.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: General Discussion

Ashish Singhal — — source: Usenet: comp.databases.informix

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

↪ replying to Ashish Singhal
Obnoxio The Clown — — source: Usenet: comp.databases.informix

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.

↪ replying to Obnoxio The Clown
Ashish Singhal — — source: Usenet: comp.databases.informix

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.

↪ replying to Ashish Singhal
Obnoxio The Clown — — source: Usenet: comp.databases.informix

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.

Related threads

Glossary