Re: Adding NO LOCK to SQL?

philcya@aol.com wrote: : 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. Only if the database is created MODE ANSI. ANSI databases default to isolation level Repeatable Read. This is an ANSI requirement, not an Informix one. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Menlo Park ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.