Re: Description of ROWID
--0__=88BBE4D8DFCAA0768f9e8a93df938690918c88BBE4D8DFCAA076 Content-type: multipart/alternative; Boundary="1__=88BBE4D8DFCAA0768f9e8a93df938690918c88BBE4D8DFCAA076" --1__=88BBE4D8DFCAA0768f9e8a93df938690918c88BBE4D8DFCAA076 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable The ROWID is an internal PHYSICAL representation of a data row. The for= mat of the ROWID is 0xLLLLLLSS where L =3D Logical page offset within the t= able (tablespace as we call it in Informix) and SS =3D Slot# within the page= . Since, its a physical representation (engine uses it to access the row requested) its not advisable to use it as a PRIMARY KEY .. u r essentia= lly flirting with danger using that ... HTH Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 If we all did the things we are capable of doing, we would literally astound ourselves. -- T. Edison = "Joachim Engel" = <joachim.engel@en = gel-edv.de> = To Sent by: informix-list@iiug.org = owner-informix-li = cc st@iiug.org = Subj= ect Description of ROWID = 03/02/2004 04:34 = AM = = = Please respond to = "Joachim Engel" = = = Hi, does anyone have some background information about the ROWID column? Can I used it as primary key for temporary result sets on the client side? Why are the nummbers not successive? TIA Joachim Engel = --1__=88BBE4D8DFCAA0768f9e8a93df938690918c88BBE4D8DFCAA076 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>The ROWID is an internal PHYSICAL representation of a data row. The = format of the ROWID is 0xLLLLLLSS where L =3D Logical page offset withi= n the table (tablespace as we call it in Informix) and SS =3D Slot# wit= hin the page. <br> <br> Since, its a physical representation (engine uses it to access the row = requested) its not advisable to use it as a PRIMARY KEY .. u r essentia= lly flirting with danger using that ...<br> <br> HTH<br> <br> Thanx much,<br> <br> Rajib Sarkar<br> Advisory Software Engineer (RAS)<br> IBM Data Management Group <br> Ph : (602)-217-2100<br> Fax: (602)-217-2100<br> T/L : 667-2100<br> <br> If we all did the things we are capable of doing, we would literally as= tound ourselves. -- T. Edison<br> <br> <img src=3D"cid:10__=3D88BBE4D8DFCAA0768f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Joachim Engel= " <joachim.engel@engel-edv.de>">"Joachim Engel" &l= t;joachim.engel@engel-edv.de><br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D88BBE4D= 8DFCAA0768f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">"Joachim Engel" <joachim.engel@eng= el-edv.de></font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: owner-informix-list@iiug.org</font> <p><font size=3D"2">03/02/2004 04:34 AM</font> <table border=3D"1"> <tr valign=3D"top"><td width=3D"168" bgcolor=3D"#FFFFFF"><div align=3D"= center"><font size=3D"2">Please respond to<br> "Joachim Engel"</font></div></td></tr> </table> </ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE4D8DFCAA0768f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE4D8DFCAA0768f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">informix-list@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE4D8DFCAA0768f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D88BBE4D8DFCAA0768f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D88BBE4D8DFCAA0768f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D88BBE4D8DFCAA0768f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">Description of ROWID</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D88BBE4D8DFCA= A0768f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D88BBE4D8DFCAA0768f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr>@@NL@