Negative ROWID
I'm trying to use the ROWID value for segmenting a table unload, but I'm having a problem with negative ROWIDs. In the past I was able to get past the issue by rebuilding(defragging) the table, the results were all positive ROWIDs starting with 257. Presently, the rebuilding of a table is not yielding the same results as last time, I'm still ending up with negative ROWIDs. I'm wondering if I just go luck the previous times. Are negative ROWIDs normal? If not, is there an official method for clearing this up? I'm running IDS 7.31 on HP-UX 11.0.B Thanks in Advance. Anthony Ojeda Sr. Systems Administrator LATHAM & WATKINS LLP 555 West Fifth Street, Suite 800 Los Angeles, CA 90013-1010 Direct Dial: (213) 891-7211 Fax: (213) 891-7123 Email: anthony.ojeda@lw.com www.lw.com ******************************************************************************* To comply with IRS regulations, we advise you that any discussion of Federal tax issues in this e-mail was not intended or written to be used, and cannot be used by you, (i) to avoid any penalties imposed under the Internal Revenue Code or (ii) to promote, market or recommend to another party any transaction or matter addressed herein. For more information please go to http://www.lw.com/resource/Publications/_pdf/pub1289_1.pdf ******************************************************************************* This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies. Latham & Watkins LLP
On 7/9/06, Anthony.Oje.... <Anthony.Ojeda@lw.com> wrote: > > I'm trying to use the ROWID value for segmenting a table unload, but > I'm having a problem with negative ROWIDs. In the past I was able to > get past the issue by rebuilding(defragging) the table, the results > were all positive ROWIDs starting with 257. Presently, the rebuilding > of a table is not yielding the same results as last time, I'm still > ending up with negative ROWIDs. I'm wondering if I just go luck the > previous times. Are negative ROWIDs normal? If not, is there an > official method for clearing this up? > > I'm running IDS 7.31 on HP-UX 11.0.B ROWID values are best thought of as unsigned 32-bit numbers stored in a signed 32-bit column; of course, they actually aren't stored at all (except in fragmented tables created WITH ROWIDS). What a negative value suggest to me is that your ROWID value has a value 0x80000000 or larger, and this shows as a negative number. Normal - no. Incorrect - not necessarily. Chat to Tech Support. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/