Re: Using ROWID for selecton/identification ??? better think again

Ever heard of legacy code and backwards compatibility? -perry On 3 Jul 1997 19:43:04 -0400, fmathews@systems.dhl.com (Felix Koshy Mathews) wrote: >Recently people have been following the link of "How to limit rows >selected?". There were a few suggestions which uses ROWID for selection. > >In later versions of Informix, by default, this so called ROWID is >available only in NON-FRAGMENTED tables. If the table is going to be >fragmented one, then by adding WITH ROWIDS clause to your create table >statement (available only in On-Line) Informix will add a column by the >name ROWID to that tbale, which will have unique values. But this not an >indexed column, still people want to use it ??? I don't get it ??? > >-- >Have a nice day > >Felix K. Mathews >mailto:fmathews@systems.dhl.com