Re: adjacent row delete bug

} From: kwa@mtatm.mt.att.com (K.ANDERSON(MT5756)XXXX) } [...] } We are now seeing the problem with NON-adjacent rows. I am assuming we } are banging up against another bug. } } Does anyone know a another like bug ?? } Maybe it's not a bug. Are you using the default page lock mode? Use tbcheck to find out, and alter table to "correct" it. See the Informix Guide to SQL Tutorial, pg 7-22, "Concurrency & Locking" } While we are one the subject data and indices storage ... how does one } determine the order of data and the related indeces ?? Is the ordering } different for clustered indices(I assume so.) See the Informix Guide to SQL Tutorial, pg 10-24, "Clustered Indexes" (and the rest of the book, too) } We are running HP-UX 9.01 } } INFORMIX EMBEDDED SQL for C Version 5.00.UC1 } INFORMIX-4GL Run Time Facility Version 4.10.UE2 } INFORMIX-SQL Version 4.10.UE2 } INFORMIX-OnLine Version 5.00.UC4 } } Thanks in advance. } Keith __________________________________________________________________ | Clem Akins Standard Disclaimers Apply | |Reynolds Metals Co, Alloys Plant "Climb High, Cave Deep!" | | Muscle Shoals, Alabama USA cwakins@leia.alloys.rmc.com | |________________________________________________________________|