Re: Multiple Update Problem

Victor M. Castillo wrote: > Hi I am new to the Informix user group and I thought maybe some one > out there can help me. I am having a problem with updating using > Informix 4GL. The problem goes like this, whenever a user holds a > record for update, say record 100, nobody can update records with a > record number greater than 100, however records with a record number > less than 100 can be updated. This is probably a problem with the table design (OK, index design), and perhaps a function of how the UPDATE statement is written. Are you using SE, perchance, as your database engine? Anyway, if you are updating records without using an index, then your changes can cause the table to appear locked to other users. Usually, if you are using an index, then this is not a problem. Also, if either UPDATE is scanning the table, then your locks are going to cause problems for the process which scans the table. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix -- see http://www.perl.com/CPAN #include <disclaimer.h>