Re: Row Level Locking. Informix vs. Oracle

In fact, Oracle only has row and table level locking in 7.X. Many times I have found page level locking to be invaluable when working with Informix based applications ( i.e. Peoplesoft ). SaTriGuy wrote: > > >Recently I was in a discussion with an Oracle DBA > >and he stated the Oracle has row level locking, where Informix has page level > > > >locking. I went to Informix's web site and from what I can tell Informix ODS > > > >does row level locking. However, the Oracle DBA insists Informix does > >not have row level locking. Ok, could somebody please tell me who is > >correct, > >or am I misunderstanding the concept of row level locking. > > > > > >Thanks > >Peter > > Informix has rowlevel locking as well as page level locking. This is defined > when the table is created or altered with the LOCK MODE ROW. Page level > locking is the default. You Oracle DBA friend was incorrect. > > Madison Pruet -- Tony Johnson Email : rp2360@email.sps.mot.com Senior Database Administrator Voice : ( 602 ) 655 - 4617 Motorola SPS / Western Region CIM Pager : ( 602 ) 409 - 4481 2200 W. Broadway Rd. MD M555 Fax : ( 602 ) 655 - 3569 Mesa, AZ 85202 ---------------------------------------------------------------------------- We Are One. One Team. One Voice. One Objective : To Be No. 1 With Our Customers. No RAS. DWYSYWD. LOPOYPDNNMAEOMP. Top Box. WDIRTFTWYCDIA. Murphy's Constant: Data will be damaged in direct proportion to its value