Re: Rowid range in Informix 7.x

In article <6et2s1$ri1@news.informix.com>, Birdman <fanjun@writeme.com> writes >Hi, > >Pawan Mathur wrote in message <3511B6DD.41C67EA6@cig.mot.com>... >>Hi. >>I am using the column "rowid" to access all rows of a temporary table. >>Since a "rowid" contains page number in its most significant 3 bytes, >>is it possible that the rowids may not be sequential? >Yes, until you delete some later. > >>Also, if the row numbers is very large, do they wrap around, so that >>a min(rowid) may be less than a max(rowid) for a table? >Impossible, it would cause error when rows exceeding the limit. > It DOES wrap, however if an existing row has the new value then it fails i.e. it will not skip over existing values. >>Is a Informix 4gl INTEGER variable sufficient to contain the possible >>values of a rowid? > >Yes, as long as 4gl INTEGER is 4 byte long. > Which it will be since it is defined as +/- 2 billion. >>Thanks and Regards, >>Pawan. > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care