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.