Re: rowid no longer unique?

I'm one of those puriest!!! IF Informix would have never allowed this in the first place, this probally would not have happend in the Real World.... I say this is the time to "GET the Model Corrected" if at ALL possible (cost of correctting this NOW, will be cheper then trying to fix data and code further down the road). But anyway Informix being the Nice Cust company did allow the option of building tables with the "ROWID" column. Check it out in the 7.x doc for table creation. What other things you must consider and how it works I'm not clear on.... since as DBA at my site I making this Number on the PGM list of this to change in going from 5 to 7. Yet as you say in the REAL WORLD everyone may not be able to correct this!!!! Hopes this is of some Help! ------------------------------------------------------------------------- Cheryl Kendricks Internet:cherylk@prod1.jcdc.doleta.gov OR cherylk@gwysmtp.jcdc.doleta.gov DTSI, Inc. Voice: 1-800-598-5008 Fax: 512-393-7296 Database Administrator - DOL Job Corps San Marcos, Texas ------------------------------------------------------------------------ On 31 May 1996, Ron wrote: > I think I remember seeing something in this bb about rowid no longer being > necessarily unique within a table for v7. Is this true? More than once, > while coding with ESQL, I coded a singleton select that I knew would return > more than one row so I just added a where clause to avoid opening a cursor: > > select col from tab where rowid = > (select max(rowid) from tab where key = "somevalue")> > Some purists might say that the model is not properly constructed if I have > to do this but sometimes when you are dealing in the real world, well.... > > So, is it true? Thanks in advance. > > > Ron Cichoski > rcichoski@adventcon.com > >