Re: Row Level Locking. Informix vs. Oracle

Hold on now. Sybase (Adaptive Server 11.5) does support row-level locking. -- Thanks, G.Carter Sybase Replication Agent Development greg.carter@homemail.com greg.carter@workmail.com http://www.webaccess.net/~greg.carterMichael Segel wrote: > > Peter J. Diaz de Leon 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 > > Your Oracle DBA buddy is pulling your leg. (I think Informix had Row level locking > before > Oracle while Sybase still doesn't have it.) > > Informix defaults to page level, but you can do row level locking. > In Turbo, and I think 5.x, both the row and its adjacent neighbors got locked. > But since I have altzhimers at an early age, (31), don't quote me. > > -Mikey