Re: ROWID Question

Posted in 1996

Peter Sylvester — Fri, 08 Nov 1996 07:07:33 -0500 — source: Informix-list mailing list archive (1991-1998)

Tim Porreca wrote: > > In 7.2 DS, if I have a table in which I NEVER delete records, will the > ROWIDs be added sequentially? We have notes tables which need to be > retrieved in formcode in the order they were entered. > > Tim I thought this was the case, and based some code on that fact; but there has been at least one case where I have observed that Online used a single higher rowid, then went back and started filling in where it left off. I havn't figured out what triggered this behavior, but I'd be interested in hearing from someone who knows more (Informix?). I'm running 7.12 on Solaris. -Peter