Re: Locking problem in INFORMIX ONLINE 7.20. UC2 -Reply

What are the difference between lock mode row and lock mode page? Should I create the tables with lock mode row? I am going to create database and build new schema on Online 7.20 in a few days. Since I upgraded to Online 7.20 from 5.03, Do I need to create the tables with extent size next size in order to keep less than 8 extents? Does Online 7.20 handle it automatically? On 5.03, I created each table with extent size next size in the past. Thuc >>> W Mat Waites <ren1347@ghps.com> 07/10/97 07:59am >>> In article <5ptfiu$qlv@cssun.mathcs.emory.edu> infodsh@emirates.net.ae ("Infodata Ltd. (Sharjah) U.A.E.") writes: >Dear friends, > >My problem is as follows : ... > >What I want to say is that IT LOCKS MORE THAN ONE ROW ( all rows after the >locked row). Is this O.K. or an bug or am I doing some mistake in >understanding it. > > Please throw some light if U can. > >Thanks > >Bharat Shah Did you create the table with lock mode row? lock mode page is the unfortunate default Mat -- W Mat Waites | mwaites@ghps.com GAMBRO Healthcare Patient Services | (615) 320-4410 Nashville, TN |