Re: Adding NO LOCK to SQL?

> Our Director over our DBA group announced today that we in application > development need to go back to all our existing applications and add 'NO > LOCK' to all our SQL statements. If we don't, he claims that Informix > 7.12 will automatically put a share lock on the row that has been read and > will not release the lock until the transaction is committed. > > I cannot believe that Informix automatically assumes pestimistic locking > in all cases. Does anyone know if this is true or not? [Very rude word snipped.] This is only true if you're using REPEATABLE READ. And if you use REPEATABLE READ as your default isolation level, you might be using a very inappropriate isolation level. HTH. -- Ciao, Billy NOTE: 1000's of programs for download at http://*&^*%!#+^|@$*)(?><"NO CARRIER