Re: Rowid range in Informix 7.x

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. >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. >Thanks and Regards, >Pawan.