Re: Missing feature in informix?

Gnana1 (gnana1@aol.com) wrote: : Informix does have this feature. : select * from tablea where rowid > 10 and rowid < 20. : Ravi. Unfortunately, this will not work. Someone already mentioned the problems if the table is fragmented across dbspaces, and someone also mentioned the recommendations about not using rowids in 7.X and above. The select above may or may not return rows....the rowid will be assigned based on the internal algorithm....It does not necessarily appear in any certain order....what happens if rowid 15 has been deleted and the space successfully reused? Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------