Re: ROWID Question

Peter Sylvester wrote: > Question: Are ROWIDs for newly inserted records always higher than the > highest existing ROWID in the given (non-fragmented) table ? > Only if your table is static or doesn't delete pre-existing rows. (So the answer is no.) > If records are deleted from the table, will Informix reuse their old rowids > for new inserts ? What if delete all the rows from the table ocasionally? > Yes. > I'm not planning on storing the rowid values, just using the last one found > for the next scan of the table. I understand (from Informix documentation) > that ROWIDs may not be sequential, and that fragmented tables have some > peculiar properties. Because of replication that is taking place on this > table, I'd prefer to stay away from trigger based solutions. > Why not use a serial field? What you could do is create a small table which has the table id and a serial field as a counter. But in general, what your asking doesn.'t make sense. What is the functionality you are trying to achieve? -Mikey